APPS.PSP_ENC_ASSIGNMENT_CHANGES dependencies on PER_PERSON_TYPES

Line 633: from per_all_people_f papf, per_person_types ppt

629: --Bug 12969737 Begin
630:
631: cursor cancel_hire_asg_csr(p_person_id number) is
632: select min(papf.EFFECTIVE_START_DATE),max(papf.EFFECTIVE_END_DATE)
633: from per_all_people_f papf, per_person_types ppt
634: where papf.person_id = p_person_id
635: and papf.PERSON_TYPE_ID = ppt.PERSON_TYPE_ID
636: and ppt.SYSTEM_PERSON_TYPE = 'EMP';
637: