APPS.PER_ASG_BUS2 dependencies on PER_ASS_STATUS_TYPE_AMENDS

Line 2204: FROM per_ass_status_type_amends

2200: l_bg_id per_all_people_f.business_group_id%TYPE;
2201: --
2202: CURSOR csr_chk_amends (p_bg_id per_all_people_f.business_group_id%TYPE) IS
2203: SELECT per_system_status
2204: FROM per_ass_status_type_amends
2205: WHERE assignment_status_type_id = per_asg_shd.g_old_rec.assignment_status_type_id
2206: AND business_group_id = csr_chk_amends.p_bg_id;
2207: --
2208: CURSOR csr_valid_ast IS