DBA Data[Home] [Help]

APPS.PA_INVOICE_DETAIL_PROCESS dependencies on PA_CC_DIST_LINES

Line 14: FROM PA_CC_DIST_LINES CCDIST

10: /* Cursor to get CC Distribution */
11: cursor get_cc_dist ( l_exp_item_id IN NUMBER )
12: is
13: SELECT CCDIST.rowid,CCDIST.*
14: FROM PA_CC_DIST_LINES CCDIST
15: WHERE CCDIST.EXPENDITURE_ITEM_ID = l_exp_item_id
16: AND CCDIST.LINE_NUM = ( SELECT MAX(L.LINE_NUM)
17: FROM PA_CC_DIST_LINES L
18: WHERE L.EXPENDITURE_ITEM_ID =

Line 17: FROM PA_CC_DIST_LINES L

13: SELECT CCDIST.rowid,CCDIST.*
14: FROM PA_CC_DIST_LINES CCDIST
15: WHERE CCDIST.EXPENDITURE_ITEM_ID = l_exp_item_id
16: AND CCDIST.LINE_NUM = ( SELECT MAX(L.LINE_NUM)
17: FROM PA_CC_DIST_LINES L
18: WHERE L.EXPENDITURE_ITEM_ID =
19: CCDIST.EXPENDITURE_ITEM_ID);
20:
21: --