APPS.PER_ASG_BUS1 dependencies on PER_ASS_STATUS_TYPE_AMENDS

Line 3992: -- PER_ASS_STATUS_TYPE_AMENDS for the assignment business group.

3988: from per_business_groups_perf
3989: where business_group_id = p_rec.business_group_id;
3990: --
3991: -- Cursor to check if the assignment status type exists in
3992: -- PER_ASS_STATUS_TYPE_AMENDS for the assignment business group.
3993: --
3994: cursor csr_chk_amends is
3995: select active_flag, per_system_status
3996: from per_ass_status_type_amends

Line 3996: from per_ass_status_type_amends

3992: -- PER_ASS_STATUS_TYPE_AMENDS for the assignment business group.
3993: --
3994: cursor csr_chk_amends is
3995: select active_flag, per_system_status
3996: from per_ass_status_type_amends
3997: where assignment_status_type_id = p_rec.assignment_status_type_id
3998: and business_group_id = p_rec.business_group_id;
3999: --
4000: -- Cursor to retrieve the existing PER_SYSTEM_STATUS for the

Line 4383: -- PER_ASS_STATUS_TYPE_AMENDS for the assignment business group.

4379: hr_utility.set_location(l_proc, 70);
4380: end if;
4381: --
4382: -- Check if the assignment status type exists in
4383: -- PER_ASS_STATUS_TYPE_AMENDS for the assignment business group.
4384: --
4385: open csr_chk_amends;
4386: fetch csr_chk_amends into l_active_flag, l_per_system_status;
4387: if csr_chk_amends%notfound then