I found what I'm looking for in ci_plsql_modules, but I can't connect the procedure to its package.
I found both objects here, but can't see how to connect them.
I want to concatenate the package implementation name with the procedure implementation name.
I see both implementation names here, but the procedure doesn't have a parent IVID. They're connected in designer so there must be some way to link them via the d.b.
SELECT pl.implementation_name, sv.vlabel, pl.parent_ivid, pl.top_level_flag
FROM ci_plsql_modules PL
INNER JOIN sdd\_object\_versions sv ON sv.name = pl.short\_name
WHERE upper(pl.short_name) = UPPER('&short_name')
AND jr_version.is_latest_version@devel(pl.ivid) = 1
AND jr_version.is_latest_version@devel(sv.ivid) = 1
UNION
SELECT pl.implementation_name, sv.vlabel, pl.parent_ivid, pl.top_level_flag
FROM ci_plsql_modules PL
INNER JOIN sdd\_object\_versions sv ON sv.name = pl.short\_name
WHERE upper(pl.short_name) = UPPER('&short_name2')
AND jr_version.is_latest_version@devel(pl.ivid) = 1
AND jr_version.is_latest_version@devel(sv.ivid) = 1