DBA Data[Home] [Help]

APPS.PA_OTC_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 4817: select max(person_id) from per_all_assignments_f paf,per_assignment_status_types past

4813: And Lookup_Code = P_Lookup_Code;
4814:
4815: /* For Bug 7645561*/
4816: Cursor Check_Term_with_pay(p_person_id IN NUMBER) is
4817: select max(person_id) from per_all_assignments_f paf,per_assignment_status_types past
4818: where paf.person_id = p_person_id
4819: and paf.assignment_status_type_id = past.assignment_status_type_id
4820: and past.per_system_status = 'TERM_ASSIGN';
4821: /* For Bug 7645561*/