DBA Data[Home] [Help]

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;