APPS.PER_PPB_BUS dependencies on PER_PAY_BASES

Line 30: , per_pay_bases ppb

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , per_pay_bases ppb
31: where ppb.pay_basis_id = p_pay_basis_id
32: and pbg.business_group_id = ppb.business_group_id;
33: --
34: -- Declare local variables

Line 94: , per_pay_bases ppb

90: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , per_pay_bases ppb
95: where ppb.pay_basis_id = p_pay_basis_id
96: and pbg.business_group_id = ppb.business_group_id;
97: --
98: -- Declare local variables

Line 204: per_ppb_shd.constraint_error('PER_PAY_BASES_PK');

200: <> per_ppb_shd.g_old_rec.pay_basis_id) then
201: --
202: -- raise error as PK has changed
203: --
204: per_ppb_shd.constraint_error('PER_PAY_BASES_PK');
205: --
206: elsif not l_api_updating then
207: --
208: -- check if PK is null

Line 214: per_ppb_shd.constraint_error('PER_PAY_BASES_PK');

210: if p_pay_basis_id is not null then
211: --
212: -- raise error as PK is not null
213: --
214: per_ppb_shd.constraint_error('PER_PAY_BASES_PK');
215: --
216: end if;
217: --
218: end if;

Line 231: -- Validates that RATE_ID in the PER_PAY_BASES table

227: -- ---------------------------------------------------------------------------
228: --
229: -- Desciption :
230: --
231: -- Validates that RATE_ID in the PER_PAY_BASES table
232: -- exists for the record specified by RATE_ID.
233: --
234: -- Pre-conditions:
235: -- None.

Line 279: per_ppb_shd.constraint_error(p_constraint_name => 'PER_PAY_BASES_FK2');

275: fetch csr_salary_basis into l_exists;
276: if p_rate_id is not null then
277: if csr_salary_basis%notfound then
278: close csr_salary_basis;
279: per_ppb_shd.constraint_error(p_constraint_name => 'PER_PAY_BASES_FK2');
280: end if;
281:
282: close csr_salary_basis;
283: end if;

Line 297: -- Validates that NAME in the PER_PAY_BASES table

293: -- ---------------------------------------------------------------------------
294: --
295: -- Desciption :
296: --
297: -- Validates that NAME in the PER_PAY_BASES table
298: -- exists for the record specified by NAME.
299: --
300: -- Pre-conditions:
301: -- None.

Line 331: from per_pay_bases ppb

327: l_api_updating boolean;
328: --
329: cursor csr_name is
330: select 'Y'
331: from per_pay_bases ppb
332: where upper(ppb.name) = upper(p_name)
333: and ppb.business_group_id = p_business_group_id
334: --4154786
335: and ppb.pay_basis_id <> p_pay_basis_id

Line 444: -- Validates that pay_annualization_factor in the PER_PAY_BASES table

440: -- ---------------------------------------------------------------------------
441: --
442: -- Desciption :
443: --
444: -- Validates that pay_annualization_factor in the PER_PAY_BASES table
445: -- has a meanigful value
446: --
447: -- Pre-conditions:
448: -- None.

Line 524: -- Validates that grade_annualization_factor in the PER_PAY_BASES table

520: -- ---------------------------------------------------------------------------
521: --
522: -- Desciption :
523: --
524: -- Validates that grade_annualization_factor in the PER_PAY_BASES table
525: -- has a meanigful value, if p_rate_basis is entered
526: --
527: -- Pre-conditions:
528: -- None.

Line 1267: ,p_descflex_name => 'PER_PAY_BASES'

1263: -- b) During insert.
1264: --
1265: hr_dflex_utility.ins_or_upd_descflex_attribs
1266: (p_appl_short_name => 'PER'
1267: ,p_descflex_name => 'PER_PAY_BASES'
1268: ,p_attribute_category => p_rec.ATTRIBUTE_CATEGORY
1269: ,p_attribute1_name => 'ATTRIBUTE1'
1270: ,p_attribute1_value => p_rec.attribute1
1271: ,p_attribute2_name => 'ATTRIBUTE2'

Line 1464: , per_pay_bases ppb

1460: Begin
1461: select pbg.legislation_code
1462: into l_leg_code
1463: from per_business_groups_perf pbg
1464: , per_pay_bases ppb
1465: where ppb.pay_basis_id = p_rec.pay_basis_id
1466: and pbg.business_group_id = ppb.business_group_id;
1467: --
1468: hr_utility.set_location('Entering:'||l_proc, 5);