eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_XRF_BUS dependencies on PER_BUSINESS_GROUPS

Line 71: from per_business_groups pbg

67: -- Declare cursor
68: --
69: cursor csr_sec_grp is
70: select pbg.security_group_id
71: from per_business_groups pbg
72: , ben_ext_rcd_in_file xrf
73: where xrf.ext_rcd_in_file_id = p_ext_rcd_in_file_id
74: and pbg.business_group_id = xrf.business_group_id;
75: --

Line 1299: from per_business_groups a,

1295: -- Declare cursor
1296: --
1297: cursor csr_leg_code is
1298: select a.legislation_code
1299: from per_business_groups a,
1300: ben_ext_rcd_in_file b
1301: where b.ext_rcd_in_file_id = p_ext_rcd_in_file_id
1302: and a.business_group_id(+) = b.business_group_id;
1303: --

Line 1306: l_legislation_code per_business_groups.legislation_code%type ;

1302: and a.business_group_id(+) = b.business_group_id;
1303: --
1304: -- Declare local variables
1305: --
1306: l_legislation_code per_business_groups.legislation_code%type ;
1307: l_proc varchar2(72) := g_package||'return_legislation_code';
1308: --
1309: begin
1310: --