DBA Data[Home] [Help]

APPS.PA_UTILS4 dependencies on PER_PEOPLE_F

Line 1370: from PER_PEOPLE_F P

1366: begin
1367: if NVL (G_INCURRED_BY_PERSON_ID,0) <> p_incurred_by_person_id THEN
1368: select P.FULL_NAME,NVL(P.EMPLOYEE_NUMBER,P.NPW_NUMBER)
1369: into G_full_name, G_employee_number
1370: from PER_PEOPLE_F P
1371: WHERE P.PERSON_ID = p_incurred_by_person_id
1372: AND TRUNC(p_EXPENDITURE_ENDING_DATE) BETWEEN P.EFFECTIVE_START_DATE AND P.EFFECTIVE_END_DATE ;
1373: end if ;
1374: