APPS.PA_BILLING dependencies on PA_DRAFT_REVENUES_ALL

Line 1352: PA_DRAFT_REVENUES_ALL DR,

1348: SUM(NVL(ERDL.projfunc_revenue_amount,0)),SUM(NVL(ERDL.funding_revenue_amount,0))
1349: INTO x_revproc_writeoff_amount,x_project_writeoff_amount,
1350: x_projfunc_writeoff_amount,p_writeoff_amount /* MCB related changes */
1351: FROM PA_CUST_EVENT_RDL_ALL ERDL,
1352: PA_DRAFT_REVENUES_ALL DR,
1353: PA_EVENT_TYPES ET,
1354: PA_EVENTS E
1355: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1356: AND ERDL.PROJECT_ID=DR.PROJECT_ID

Line 1426: PA_DRAFT_REVENUES_ALL DR,

1422: SUM(NVL(ERDL.projfunc_revenue_amount,0)),SUM(NVL(ERDL.funding_revenue_amount,0))
1423: INTO x_revproc_writeoff_amount,x_project_writeoff_amount,
1424: x_projfunc_writeoff_amount,p_writeoff_amount /* MCB related changes */
1425: FROM PA_CUST_EVENT_RDL_ALL ERDL,
1426: PA_DRAFT_REVENUES_ALL DR,
1427: PA_EVENT_TYPES ET,
1428: PA_EVENTS E
1429: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1430: AND ERDL.PROJECT_ID=DR.PROJECT_ID

Line 1491: PA_DRAFT_REVENUES_ALL DR,

1487: SUM(NVL(ERDL.projfunc_revenue_amount,0)),SUM(NVL(ERDL.funding_revenue_amount,0))
1488: INTO x_revproc_writeoff_amount,x_project_writeoff_amount,
1489: x_projfunc_writeoff_amount,p_writeoff_amount /* MCB related changes */
1490: FROM PA_CUST_EVENT_RDL_ALL ERDL,
1491: PA_DRAFT_REVENUES_ALL DR,
1492: PA_EVENT_TYPES ET,
1493: PA_EVENTS E
1494: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1495: AND ERDL.PROJECT_ID=DR.PROJECT_ID

Line 1517: PA_DRAFT_REVENUES_ALL DR,

1513: SUM(NVL(ERDL.projfunc_revenue_amount,0)),SUM(NVL(ERDL.funding_revenue_amount,0))
1514: INTO x_revproc_writeoff_amount,x_project_writeoff_amount,
1515: x_projfunc_writeoff_amount,p_writeoff_amount /* MCB related changes */
1516: FROM PA_CUST_EVENT_RDL_ALL ERDL,
1517: PA_DRAFT_REVENUES_ALL DR,
1518: PA_EVENT_TYPES ET,
1519: PA_EVENTS E
1520: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1521: AND ERDL.PROJECT_ID=DR.PROJECT_ID