APPS.PSP_PSPLDAWD_XMLP_PKG dependencies on PER_ASSIGNMENTS_F
Line 153: PER_ASSIGNMENTS_F
149: SELECT
150: ASSIGNMENT_NUMBER
151: INTO V_ASSIGNMENT_NUMBER
152: FROM 153: PER_ASSIGNMENTS_F 154: WHERE ASSIGNMENT_ID = CF_ASSIGNMENT_NUMBERFORMULA.ASSIGNMENT_ID
155: AND PERSON_ID = CF_ASSIGNMENT_NUMBERFORMULA.PERSON_ID
156: AND ( P_END_DATE BETWEEN EFFECTIVE_START_DATE
157: AND EFFECTIVE_END_DATE )