DBA Data[Home] [Help]

APPS.PAY_PWO_BUS dependencies on PAY_WCI_OCCUPATIONS

Line 56: pay_pwo_shd.constraint_error('PAY_WCI_OCCUPATIONS_PK');

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

Line 66: pay_pwo_shd.constraint_error('PAY_WCI_OCCUPATIONS_PK');

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

Line 209: pay_wci_occupations b

205: --
206: cursor csr_leg_code is
207: select a.legislation_code
208: from per_business_groups a,
209: pay_wci_occupations b
210: where b.occupation_id = p_occupation_id
211: and a.business_group_id = b.business_group_id;
212: --
213: -- Declare local variables