APPS.PER_ASG_BUS2 dependencies on PER_ASS_STATUS_TYPE_AMENDS

Line 2164: FROM per_ass_status_type_amends

2160: l_bg_id per_all_people_f.business_group_id%TYPE;
2161: --
2162: CURSOR csr_chk_amends (p_bg_id per_all_people_f.business_group_id%TYPE) IS
2163: SELECT per_system_status
2164: FROM per_ass_status_type_amends
2165: WHERE assignment_status_type_id = per_asg_shd.g_old_rec.assignment_status_type_id
2166: AND business_group_id = csr_chk_amends.p_bg_id;
2167: --
2168: CURSOR csr_valid_ast IS