DBA Data[Home] [Help]

APPS.PO_ENCUMBRANCE_PREPROCESSING dependencies on PO_CLMREQ_DIST_DETAILS_V

Line 8507: FROM PO_CLMREQ_DIST_DETAILS_V PCDD

8503: BEGIN
8504: UPDATE PO_ENCUMBRANCE_GT MAIN_DISTS
8505: SET (MAIN_DISTS.CHANGE_IN_FUNDED_VALUE, MAIN_DISTS.PRE_ROUND_AMT, MAIN_DISTS.FINAL_AMT)
8506: = (SELECT NVL(PCDD.FUNDS_REMAINING,0), NVL(PCDD.FUNDS_REMAINING,0), NVL(PCDD.FUNDS_REMAINING,0)
8507: FROM PO_CLMREQ_DIST_DETAILS_V PCDD
8508: WHERE PCDD.DISTRIBUTION_ID = MAIN_DISTS.DISTRIBUTION_ID
8509: AND NVL(PCDD.IS_FUNDS_REMAINING,'N') = 'Y')
8510: WHERE MAIN_DISTS.ORIGIN_SEQUENCE_NUM IS NULL
8511: AND MAIN_DISTS.CLM_DOC_FLAG = 'Y'