APPS.PA_BILLING dependencies on PA_DRAFT_REVENUES_ALL

Line 1423: PA_DRAFT_REVENUES_ALL DR,

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

Line 1497: PA_DRAFT_REVENUES_ALL DR,

1493: SUM(NVL(ERDL.projfunc_revenue_amount,0)),SUM(NVL(ERDL.funding_revenue_amount,0))
1494: INTO x_revproc_writeoff_amount,x_project_writeoff_amount,
1495: x_projfunc_writeoff_amount,p_writeoff_amount /* MCB related changes */
1496: FROM PA_CUST_EVENT_RDL_ALL ERDL,
1497: PA_DRAFT_REVENUES_ALL DR,
1498: PA_EVENT_TYPES ET,
1499: PA_EVENTS E
1500: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1501: AND ERDL.PROJECT_ID=DR.PROJECT_ID

Line 1562: PA_DRAFT_REVENUES_ALL DR,

1558: SUM(NVL(ERDL.projfunc_revenue_amount,0)),SUM(NVL(ERDL.funding_revenue_amount,0))
1559: INTO x_revproc_writeoff_amount,x_project_writeoff_amount,
1560: x_projfunc_writeoff_amount,p_writeoff_amount /* MCB related changes */
1561: FROM PA_CUST_EVENT_RDL_ALL ERDL,
1562: PA_DRAFT_REVENUES_ALL DR,
1563: PA_EVENT_TYPES ET,
1564: PA_EVENTS E
1565: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1566: AND ERDL.PROJECT_ID=DR.PROJECT_ID

Line 1588: PA_DRAFT_REVENUES_ALL DR,

1584: SUM(NVL(ERDL.projfunc_revenue_amount,0)),SUM(NVL(ERDL.funding_revenue_amount,0))
1585: INTO x_revproc_writeoff_amount,x_project_writeoff_amount,
1586: x_projfunc_writeoff_amount,p_writeoff_amount /* MCB related changes */
1587: FROM PA_CUST_EVENT_RDL_ALL ERDL,
1588: PA_DRAFT_REVENUES_ALL DR,
1589: PA_EVENT_TYPES ET,
1590: PA_EVENTS E
1591: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1592: AND ERDL.PROJECT_ID=DR.PROJECT_ID