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_XWC_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_where_clause xwc
73: where xwc.ext_where_clause_id = p_ext_where_clause_id
74: and pbg.business_group_id = xwc.business_group_id;
75: --

Line 1146: from per_business_groups a,

1142: -- Declare cursor
1143: --
1144: cursor csr_leg_code is
1145: select a.legislation_code
1146: from per_business_groups a,
1147: ben_ext_where_clause b
1148: where b.ext_where_clause_id = p_ext_where_clause_id
1149: and a.business_group_id(+) = b.business_group_id;
1150: --

Line 1153: l_legislation_code per_business_groups.legislation_code%type ;

1149: and a.business_group_id(+) = b.business_group_id;
1150: --
1151: -- Declare local variables
1152: --
1153: l_legislation_code per_business_groups.legislation_code%type ;
1154: l_proc varchar2(72) := g_package||'return_legislation_code';
1155: --
1156: begin
1157: --