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_EPE_BUS dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 77: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_?');

73: --
74: -- raise error as FK does not relate to PK in ben_pil_elctbl_chc_popl
75: -- table.
76: --
77: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_?');
78: --
79: end if;
80: --
81: close c1;

Line 156: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT7');

152: --
153: -- raise error a PK does not relate to PK in ben_pl_typ
154: -- table.
155: --
156: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT7');
157: --
158: end if;
159: --
160: close c1;

Line 234: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT13');

230: --
231: -- raise error as FK does not relate to PK in ben_spcl_rt_oipl
232: -- table.
233: --
234: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT13');
235: --
236: end if;
237: --
238: close c1;

Line 312: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT12');

308: --
309: -- raise error as FK does not relate to PK in ben_spcl_rt_pl
310: -- table.
311: --
312: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT12');
313: --
314: end if;
315: --
316: close c1;

Line 390: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT8');

386: --
387: -- raise error as FK does not relate to PK in ben_plip
388: -- table.
389: --
390: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT8');
391: --
392: end if;
393: --
394: close c1;

Line 468: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT15');

464: --
465: -- raise error as FK does not relate to PK in ben_cmbn_ptip
466: -- table.
467: --
468: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT15');
469: --
470: end if;
471: --
472: close c1;

Line 546: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT15');

542: --
543: -- raise error as FK does not relate to PK in ben_cmbn_plip
544: -- table.
545: --
546: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT15');
547: --
548: end if;
549: --
550: close c1;

Line 624: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT9');

620: --
621: -- raise error as FK does not relate to PK in ben_ptip
622: -- table.
623: --
624: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT9');
625: --
626: end if;
627: --
628: close c1;

Line 702: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT16');

698: --
699: -- raise error as FK does not relate to PK in ben_cmbn_ptip_opt
700: -- table.
701: --
702: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT16');
703: --
704: end if;
705: --
706: close c1;

Line 780: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT3');

776: --
777: -- raise error as FK does not relate to PK in ben_pgm
778: -- table.
779: --
780: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT3');
781: --
782: end if;
783: --
784: close c1;

Line 858: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT2');

854: --
855: -- raise error as FK does not relate to PK in ben_oipl
856: -- table.
857: --
858: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT2');
859: --
860: end if;
861: --
862: close c1;

Line 936: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT2');

932: --
933: -- raise error as FK does not relate to PK in ben_pl
934: -- table.
935: --
936: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT2');
937: --
938: end if;
939: --
940: close c1;

Line 1014: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT14');

1010: --
1011: -- raise error as FK does not relate to PK in ben_bnft_prvdr_pool
1012: -- table.
1013: --
1014: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT14');
1015: --
1016: end if;
1017: --
1018: close c1;

Line 1095: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT5');

1091: --
1092: -- raise error as FK does not relate to PK in ben_prtt_enrt_rslt
1093: -- table.
1094: --
1095: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT5');
1096: --
1097: end if;
1098: --
1099: close c1;

Line 1175: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT6');

1171: --
1172: -- raise error as FK does not relate to PK in ben_per_in_ler
1173: -- table.
1174: --
1175: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT6');
1176: --
1177: end if;
1178: --
1179: close c1;

Line 1253: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT11');

1249: --
1250: -- raise error as FK does not relate to PK in ben_must_enrl_anthr_pl
1251: -- table.
1252: --
1253: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT11');
1254: --
1255: end if;
1256: --
1257: close c1;

Line 1302: from ben_elig_per_elctbl_chc a

1298: l_dummy varchar2(1);
1299: --
1300: cursor c1 is
1301: select null
1302: from ben_elig_per_elctbl_chc a
1303: where a.elig_per_elctbl_chc_id = p_int_elig_per_elctbl_chc_id;
1304: --
1305: Begin
1306: --

Line 1331: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_FK18');

1327: --
1328: -- raise error as FK does not relate to PK in
1329: -- table.
1330: --
1331: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_FK18');
1332: --
1333: end if;
1334: --
1335: close c1;

Line 1409: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_FK15');

1405: --
1406: -- raise error as FK does not relate to PK in ben_yr_perd
1407: -- table.
1408: --
1409: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_FK15');
1410: --
1411: end if;
1412: --
1413: close c1;

Line 1815: ben_elig_per_elctbl_chc b

1811: --
1812: cursor csr_leg_code is
1813: select a.legislation_code
1814: from per_business_groups a,
1815: ben_elig_per_elctbl_chc b
1816: where b.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
1817: and a.business_group_id = b.business_group_id;
1818: --
1819: -- Declare local variables