APPS.PER_ASG_BUS1 dependencies on PER_ASS_STATUS_TYPE_AMENDS

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

4110: from per_business_groups_perf
4111: where business_group_id = p_rec.business_group_id;
4112: --
4113: -- Cursor to check if the assignment status type exists in
4114: -- PER_ASS_STATUS_TYPE_AMENDS for the assignment business group.
4115: --
4116: cursor csr_chk_amends is
4117: select active_flag, per_system_status
4118: from per_ass_status_type_amends

Line 4118: from per_ass_status_type_amends

4114: -- PER_ASS_STATUS_TYPE_AMENDS for the assignment business group.
4115: --
4116: cursor csr_chk_amends is
4117: select active_flag, per_system_status
4118: from per_ass_status_type_amends
4119: where assignment_status_type_id = p_rec.assignment_status_type_id
4120: and business_group_id = p_rec.business_group_id;
4121: --
4122: -- Cursor to retrieve the existing PER_SYSTEM_STATUS for the

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

4505: hr_utility.set_location(l_proc, 70);
4506: end if;
4507: --
4508: -- Check if the assignment status type exists in
4509: -- PER_ASS_STATUS_TYPE_AMENDS for the assignment business group.
4510: --
4511: open csr_chk_amends;
4512: fetch csr_chk_amends into l_active_flag, l_per_system_status;
4513: if csr_chk_amends%notfound then