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 BEN_EXT_WHERE_CLAUSE

Line 72: , ben_ext_where_clause xwc

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: --
76: -- Declare local variables

Line 165: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_PK');

161: <> ben_xwc_shd.g_old_rec.ext_where_clause_id) then
162: --
163: -- raise error as PK has changed
164: --
165: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_PK');
166: --
167: elsif not l_api_updating then
168: --
169: -- check if PK is null

Line 175: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_PK');

171: if p_ext_where_clause_id is not null then
172: --
173: -- raise error as PK is not null
174: --
175: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_PK');
176: --
177: end if;
178: --
179: end if;

Line 249: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_FK6');

245: --
246: -- raise error as FK does not relate to PK in ben_ext_data_elmt_in_rcd
247: -- table.
248: --
249: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_FK6');
250: --
251: end if;
252: --
253: close c1;

Line 325: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_FK4');

321: --
322: -- raise error as FK does not relate to PK in ben_ext_rcd_in_file
323: -- table.
324: --
325: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_FK4');
326: --
327: end if;
328: --
329: close c1;

Line 401: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_FK3');

397: --
398: -- raise error as FK does not relate to PK in ben_ext_data_elmt_in_rcd
399: -- table.
400: --
401: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_FK3');
402: --
403: end if;
404: --
405: close c1;

Line 477: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_FK2');

473: --
474: -- raise error as FK does not relate to PK in ben_ext_data_elmt
475: -- table.
476: --
477: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_FK2');
478: --
479: end if;
480: --
481: close c1;

Line 553: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_FK1');

549: --
550: -- raise error as FK does not relate to PK in ben_ext_data_elmt
551: -- table.
552: --
553: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_FK1');
554: --
555: end if;
556: --
557: close c1;

Line 904: FROM ben_ext_where_clause xwc

900: l_api_updating boolean;
901: --
902: cursor c_xwc is
903: SELECT null
904: FROM ben_ext_where_clause xwc
905: WHERE ( business_group_id is null
906: or business_group_id = p_business_group_id )
907: and (legislation_code is null
908: or legislation_code = p_legislation_code )

Line 1147: ben_ext_where_clause b

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: --
1151: -- Declare local variables