DBA Data[Home] [Help]

APPS.BEN_AGF_BUS dependencies on BEN_AGE_FCTR

Line 56: ben_agf_shd.constraint_error('BEN_AGE_FCTR_PK');

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

Line 66: ben_agf_shd.constraint_error('BEN_AGE_FCTR_PK');

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

Line 140: ben_agf_shd.constraint_error('BEN_AGE_FCTR_FK1');

136: --
137: -- raise error as FK does not relate to PK in hr_all_organization_units
138: -- table.
139: --
140: ben_agf_shd.constraint_error('BEN_AGE_FCTR_FK1');
141: --
142: end if;
143: --
144: close c1;

Line 1008: from ben_age_fctr agf

1004: l_dummy varchar2(1);
1005: --
1006: cursor c1 is
1007: select null
1008: from ben_age_fctr agf
1009: where agf.business_group_id = p_business_group_id and
1010: agf.name = p_name;
1011: Begin
1012: --

Line 1408: ben_age_fctr b

1404: --
1405: cursor csr_leg_code is
1406: select a.legislation_code
1407: from per_business_groups a,
1408: ben_age_fctr b
1409: where b.age_fctr_id = p_age_fctr_id
1410: and a.business_group_id = b.business_group_id;
1411: --
1412: -- Declare local variables