APPS.BEN_PDT_BUS dependencies on BEN_PYMT_CHECK_DET

Line 31: , ben_pymt_check_det pdt

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , ben_pymt_check_det pdt
32: where pdt.pymt_check_det_id = p_pymt_check_det_id
33: and pbg.business_group_id = pdt.business_group_id;
34: --
35: -- Declare local variables

Line 101: , ben_pymt_check_det pdt

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , ben_pymt_check_det pdt
102: where pdt.pymt_check_det_id = p_pymt_check_det_id
103: and pbg.business_group_id = pdt.business_group_id;
104: --
105: -- Declare local variables

Line 453: ben_pty_shd.constraint_error('BEN_PYMT_CHECK_DET_PK');

449: <> ben_pdt_shd.g_old_rec.pymt_check_det_id) then
450: --
451: -- raise error as PK has changed
452: --
453: ben_pty_shd.constraint_error('BEN_PYMT_CHECK_DET_PK');
454: --
455: elsif not l_api_updating then
456: --
457: -- check if PK is null

Line 463: ben_pty_shd.constraint_error('BEN_PYMT_CHECK_DET_PK');

459: if p_pymt_check_det_id is not null then
460: --
461: -- raise error as PK is not null
462: --
463: ben_pty_shd.constraint_error('BEN_PYMT_CHECK_DET_PK');
464: --
465: end if;
466: --
467: end if;

Line 536: ben_pdt_shd.constraint_error('BEN_PYMT_CHECK_DET_FK2');

532: --
533: -- raise error as FK does not relate to PK in per_all_people_f
534: -- table.
535: --
536: ben_pdt_shd.constraint_error('BEN_PYMT_CHECK_DET_FK2');
537: --
538: end if;
539: --
540: close c1;