APPS.BEN_CPY_BUS dependencies on BEN_POPL_YR_PERD

Line 56: ben_cpy_shd.constraint_error('BEN_POPL_YR_PERD_PK');

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

Line 66: ben_cpy_shd.constraint_error('BEN_POPL_YR_PERD_PK');

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

Line 122: from ben_popl_yr_perd a,

118: from ben_yr_perd yrp
119: where yrp.yr_perd_id = p_yr_perd_id
120: and yrp.business_group_id = p_business_group_id
121: and exists (select null
122: from ben_popl_yr_perd a,
123: ben_yr_perd b
124: where a.popl_yr_perd_id <> nvl(p_popl_yr_perd_id,-1)
125: and a.pl_id = p_pl_id
126: and a.business_group_id = p_business_group_id

Line 142: from ben_popl_yr_perd a,

138: from ben_yr_perd yrp
139: where yrp.yr_perd_id = p_yr_perd_id
140: and yrp.business_group_id = p_business_group_id
141: and exists (select null
142: from ben_popl_yr_perd a,
143: ben_yr_perd b
144: where a.popl_yr_perd_id <> nvl(p_popl_yr_perd_id,-1)
145: and a.pgm_id = p_pgm_id
146: and a.business_group_id = p_business_group_id

Line 158: from ben_popl_yr_perd cpy

154: and b.end_date));
155: --
156: cursor c_duplicate is
157: select null
158: from ben_popl_yr_perd cpy
159: where (cpy.pgm_id = nvl(p_pgm_id,-1) or
160: cpy.pl_id = nvl(p_pl_id,-1))
161: and cpy.yr_perd_id = p_yr_perd_id
162: and cpy.popl_yr_perd_id <> p_popl_yr_perd_id

Line 467: ben_cpy_shd.constraint_error('BEN_POPL_YR_PERD_FK1');

463: --
464: -- raise error as FK does not relate to PK in ben_yr_perd
465: -- table.
466: --
467: ben_cpy_shd.constraint_error('BEN_POPL_YR_PERD_FK1');
468: --
469: end if;
470: --
471: close c1;

Line 631: ben_cpy_shd.constraint_error('BEN_POPL_YR_PERD_FK1');

627: --
628: -- raise error as FK does not relate to PK in ben_yr_perd
629: -- table.
630: --
631: ben_cpy_shd.constraint_error('BEN_POPL_YR_PERD_FK1');
632: --
633: end if;
634: --
635: -- compare acpt_clm_rqsts_dt to be sure it is greater or equal to

Line 749: ben_cpy_shd.constraint_error('BEN_POPL_YR_PERD_FK1');

745: --
746: -- raise error as FK does not relate to PK in ben_yr_perd
747: -- table.
748: --
749: ben_cpy_shd.constraint_error('BEN_POPL_YR_PERD_FK1');
750: --
751: end if;
752: --
753: -- compare py_clms_dt to be sure it is on or before (less than)

Line 822: -- p_popl_yr_perd_id Primary Key of BEN_POPL_YR_PERD

818: -- None.
819: --
820: -- In Parameters
821: -- p_ordr_num Sequence Number
822: -- p_popl_yr_perd_id Primary Key of BEN_POPL_YR_PERD
823: -- p_pl_id
824: -- p_business_group_id
825: --
826: -- Post Success

Line 847: from ben_popl_yr_perd

843: is
844: l_proc varchar2(72) := g_package||'chk_ordr_num_unique';
845: l_dummy char(1);
846: cursor c1 is select null
847: from ben_popl_yr_perd
848: Where popl_yr_perd_id <> nvl(p_popl_yr_perd_id,-1)
849: /* bug 2923047 -- add pgm_id also */
850: and
851: (pl_id = p_pl_id

Line 1025: ben_popl_yr_perd b

1021: --
1022: cursor csr_leg_code is
1023: select a.legislation_code
1024: from per_business_groups a,
1025: ben_popl_yr_perd b
1026: where b.popl_yr_perd_id = p_popl_yr_perd_id
1027: and a.business_group_id = b.business_group_id;
1028: --
1029: -- Declare local variables