DBA Data[Home] [Help]

APPS.PO_PALT_ASSIGNMENTS dependencies on PO_CLM_ASSGNMT_MILESTONE_DTLS

Line 201: UPDATE PO_CLM_ASSGNMT_MILESTONE_DTLS

197: last_update_login = fnd_global.login_id,
198: ACTUAL_COMPLETION_DATE = SYSDATE
199: WHERE ASSIGNMENT_ID = pAssignmentId;
200:
201: UPDATE PO_CLM_ASSGNMT_MILESTONE_DTLS
202: SET ACTUAL_COMPLETION_DATE = SYSDATE ,
203: last_updated_by = fnd_global.user_id,
204: last_update_date = SYSDATE ,
205: last_update_login = fnd_global.login_id

Line 309: FROM PO_CLM_ASSGNMT_MILESTONE_DTLS dtls, PO_CLM_ASSIGNMENTS ca

305:
306: FOR i IN 1..pAssignmentNums.Count LOOP
307:
308: SELECT Count(*) INTO l_cnt
309: FROM PO_CLM_ASSGNMT_MILESTONE_DTLS dtls, PO_CLM_ASSIGNMENTS ca
310: WHERE ca.ASSIGNMENT_NUMBER = pAssignmentNums(i)
311: AND ca.ASSIGNMENT_ID = dtls.ASSIGNMENT_ID
312: AND dtls.ACTUAL_COMPLETION_DATE IS NOT NULL;
313: