APPS.PSP_PSPLDPRJ_XMLP_PKG dependencies on PER_ASSIGNMENTS_F
Line 143: PER_ASSIGNMENTS_F
139: SELECT
140: ASSIGNMENT_NUMBER
141: INTO V_ASSIGNMENT_NUMBER
142: FROM 143: PER_ASSIGNMENTS_F 144: WHERE ASSIGNMENT_ID = ASSIGNMENT_ID_arg
145: AND ( P_END_DATE Between EFFECTIVE_START_DATE
146: AND EFFECTIVE_END_DATE )
147: AND PERIOD_OF_SERVICE_ID IS NOT NULL;