APPS.PSP_PSPLDORG_XMLP_PKG dependencies on PER_PEOPLE_F

Line 57: PER_PEOPLE_F

53: DISTINCT
54: EMPLOYEE_NUMBER
55: INTO V_EMPLOYEE_NUMBER
56: FROM
57: PER_PEOPLE_F
58: WHERE PERSON_ID = PERSON_ID1
59: AND ( V_OGM_PERIOD_END Between EFFECTIVE_START_DATE
60: AND EFFECTIVE_END_DATE );
61: ELSE

Line 66: PER_PEOPLE_F

62: SELECT
63: EMPLOYEE_NUMBER
64: INTO V_EMPLOYEE_NUMBER
65: FROM
66: PER_PEOPLE_F
67: WHERE PERSON_ID = PERSON_ID1
68: AND TRUNC(EFFECTIVE_DATE) BETWEEN EFFECTIVE_START_DATE
69: AND EFFECTIVE_END_DATE;
70: END IF;