APPS.AHL_PRD_PRINT_PVT dependencies on PER_ALL_PEOPLE_F

Line 2542: FROM PER_ALL_PEOPLE_F CS_EMPL

2538: WO.WORKORDER_NAME ,
2539: PARTY.PARTY_NAME SR_CUSTOMER_NAME,
2540: DECODE(SR_CONT.CONTACT_TYPE,'PERSON',PARTY.PARTY_NAME,
2541: (SELECT CS_EMPL.FULL_NAME
2542: FROM PER_ALL_PEOPLE_F CS_EMPL
2543: WHERE TRUNC(SYSDATE) BETWEEN CS_EMPL.EFFECTIVE_START_DATE AND CS_EMPL.EFFECTIVE_END_DATE
2544: AND CS_EMPL.PERSON_ID = SR_CONT.PARTY_ID
2545: )) SR_CONTACT_NAME,
2546: CS.PROBLEM_CODE ,