DBA Data[Home] [Help]

APPS.AP_VENDOR_PUB_PKG dependencies on PER_PEOPLE_F

Line 5255: FROM PER_PEOPLE_F PPF

5251: IF x_valid THEN
5252: BEGIN
5253: SELECT PPF.PARTY_ID
5254: INTO P_VENDOR_REC.PARTY_ID
5255: FROM PER_PEOPLE_F PPF
5256: WHERE PPF.PERSON_ID = P_VENDOR_REC.EMPLOYEE_ID
5257: AND TRUNC(SYSDATE) BETWEEN
5258: TRUNC(ppf.effective_start_date) AND
5259: TRUNC(ppf.effective_end_date);