APPS.HR_PER_TYPE_USAGE_INTERNAL dependencies on PER_ALL_ASSIGNMENTS_F

Line 1355: from per_all_assignments_f p1,

1351: cursor csr_chk_assgn_id is
1352: select 'Y'
1353: from dual
1354: where exists (select p1.assignment_id
1355: from per_all_assignments_f p1,
1356: per_all_assignments_f p2
1357: where p1.assignment_type='A'
1358: and p2.assignment_type='E'
1359: and p1.assignment_id=p2.assignment_id

Line 1356: per_all_assignments_f p2

1352: select 'Y'
1353: from dual
1354: where exists (select p1.assignment_id
1355: from per_all_assignments_f p1,
1356: per_all_assignments_f p2
1357: where p1.assignment_type='A'
1358: and p2.assignment_type='E'
1359: and p1.assignment_id=p2.assignment_id
1360: and p1.person_id=p_person_id);