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_XRC_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 xrc
73: where xrc.ext_rcd_id = p_ext_rcd_id
74: and pbg.business_group_id = xrc.business_group_id;
75: --

Line 651: from per_business_groups a,

647: -- Declare cursor
648: --
649: cursor csr_leg_code is
650: select a.legislation_code
651: from per_business_groups a,
652: ben_ext_rcd b
653: where b.ext_rcd_id = p_ext_rcd_id
654: and a.business_group_id(+) = b.business_group_id;
655: --

Line 658: l_legislation_code per_business_groups.legislation_code%type ;

654: and a.business_group_id(+) = b.business_group_id;
655: --
656: -- Declare local variables
657: --
658: l_legislation_code per_business_groups.legislation_code%type ;
659: l_proc varchar2(72) := g_package||'return_legislation_code';
660: --
661: begin
662: --