DBA Data[Home] [Help]

APPS.SSP_SSPRPSPA_XMLP_PKG dependencies on PER_ALL_PEOPLE_F

Line 56: PER_ALL_PEOPLE_F P1

52: AND PPF.EFFECTIVE_END_DATE = (
53: SELECT
54: MAX(P1.EFFECTIVE_END_DATE)
55: FROM
56: PER_ALL_PEOPLE_F P1
57: WHERE P1.PERSON_ID = PPF.PERSON_ID ) )
58: OR ( P_SESSION_DATE < PPF.EFFECTIVE_START_DATE
59: AND PPF.EFFECTIVE_START_DATE = PPF.START_DATE ) );
60: END IF;