APPS.PA_OTC_API dependencies on PER_ALL_ASSIGNMENTS_F
Line 4516: select max(person_id) from per_all_assignments_f paf,per_assignment_status_types past
4512: And Lookup_Code = P_Lookup_Code;
4513:
4514: /* For Bug 7645561*/
4515: Cursor Check_Term_with_pay(p_person_id IN NUMBER) is 4516: select max(person_id) from per_all_assignments_f paf,per_assignment_status_types past 4517: where paf.person_id = p_person_id
4518: and paf.assignment_status_type_id = past.assignment_status_type_id
4519: and past.per_system_status = 'TERM_ASSIGN';
4520: /* For Bug 7645561*/