DBA Data[Home] [Help]

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*/