DBA Data[Home] [Help]

APPS.PER_ASG_BUS2 dependencies on PER_PAY_BASES

Line 31: -- Cursor to validate that pay basis exists in PER_PAY_BASES

27: l_business_group_id per_business_groups.business_group_id%TYPE;
28: l_max_pp_chg_date date;
29: --
30: --
31: -- Cursor to validate that pay basis exists in PER_PAY_BASES
32: --
33: cursor csr_chk_pay_basis is
34: select business_group_id
35: from per_pay_bases

Line 35: from per_pay_bases

31: -- Cursor to validate that pay basis exists in PER_PAY_BASES
32: --
33: cursor csr_chk_pay_basis is
34: select business_group_id
35: from per_pay_bases
36: where pay_basis_id = p_pay_basis_id;
37: --
38: -- Cursor to validate that the validation start date for the assignment is
39: -- after all change dates for pay proposals of the assignment.

Line 94: -- Check that the pay basis exists in PER_PAY_BASES.

90: --
91: end if;
92: hr_utility.set_location(l_proc, 4);
93: --
94: -- Check that the pay basis exists in PER_PAY_BASES.
95: --
96: open csr_chk_pay_basis;
97: fetch csr_chk_pay_basis into l_business_group_id;
98: if csr_chk_pay_basis%notfound then