APPS.BEN_PEL_BUS dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 56: ben_pel_shd.constraint_error('BEN_PIL_ELCTBL_CHC_POPL_PK');

52: <> ben_pel_shd.g_old_rec.pil_elctbl_chc_popl_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_pel_shd.constraint_error('BEN_PIL_ELCTBL_CHC_POPL_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: ben_pel_shd.constraint_error('BEN_PIL_ELCTBL_CHC_POPL_PK');

62: if p_pil_elctbl_chc_popl_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: ben_pel_shd.constraint_error('BEN_PIL_ELCTBL_CHC_POPL_PK');
67: --
68: end if;
69: --
70: end if;

Line 216: ben_pel_shd.constraint_error('BEN_PIL_ELCTBL_CHC_POPL_DT2');

212: --
213: -- raise error as FK does not relate to PK in ben_per_in_ler
214: -- table.
215: --
216: ben_pel_shd.constraint_error('BEN_PIL_ELCTBL_CHC_POPL_DT2');
217: --
218: end if;
219: --
220: close c1;

Line 296: ben_pel_shd.constraint_error('BEN_PIL_ELCTBL_CHC_POPL_DT1');

292: --
293: -- raise error as FK does not relate to PK in ben_lee_rsn_f
294: -- table.
295: --
296: ben_pel_shd.constraint_error('BEN_PIL_ELCTBL_CHC_POPL_DT1');
297: --
298: end if;
299: --
300: close c1;

Line 372: ben_pel_shd.constraint_error('BEN_PIL_ELCTBL_CHC_POPL_FK1');

368: --
369: -- raise error as FK does not relate to PK in ben_enrt_perd
370: -- table.
371: --
372: ben_pel_shd.constraint_error('BEN_PIL_ELCTBL_CHC_POPL_FK1');
373: --
374: end if;
375: --
376: close c1;

Line 1258: ben_pil_elctbl_chc_popl pel1,

1254: cursor c1 is
1255: select per1.full_name person1,
1256: per2.full_name person2
1257: from ben_cwb_hrchy cwb1,
1258: ben_pil_elctbl_chc_popl pel1,
1259: ben_per_in_ler pil1,
1260: per_all_people_f per1,
1261: per_all_people_f per2
1262: where cwb1.mgr_pil_elctbl_chc_popl_id = p_pil_elctbl_chc_popl_id

Line 1274: from ben_pil_elctbl_chc_popl pel2,

1270: and trunc(p_effective_date) between per2.effective_start_date
1271: and per2.effective_end_date
1272: and exists
1273: ( select 'x'
1274: from ben_pil_elctbl_chc_popl pel2,
1275: ben_per_in_ler pil2
1276: where pil2.person_id = p_ws_mgr_id
1277: and pil2.lf_evt_ocrd_dt = pil1.lf_evt_ocrd_dt
1278: and pil2.ler_id = pil1.ler_id

Line 1625: ben_pil_elctbl_chc_popl b

1621: --
1622: cursor csr_leg_code is
1623: select a.legislation_code
1624: from per_business_groups a,
1625: ben_pil_elctbl_chc_popl b
1626: where b.pil_elctbl_chc_popl_id = p_pil_elctbl_chc_popl_id
1627: and a.business_group_id = b.business_group_id;
1628: --
1629: -- Declare local variables