eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_BILLING dependencies on PA_DRAFT_REVENUES

Line 229: (select NULL from pa_draft_revenues pdr

225: )
226: or
227: ( x_calling_process in ('Revenue','Both')
228: AND EXISTS
229: (select NULL from pa_draft_revenues pdr
230: where pdr.project_id = x_project_id
231: and pdr.request_id = x_request_id
232: and (( x_calling_place = 'ADJ'
233: and pdr.draft_revenue_num_credited is not null)

Line 1028: pa_draft_revenues dr

1024: AND pf.project_id = l_project_id
1025: AND NOT EXISTS
1026: ( SELECT null
1027: FROM pa_draft_revenue_items dri,
1028: pa_draft_revenues dr
1029: WHERE dri.project_id = dr.project_id
1030: AND dri.draft_revenue_num = dr.draft_revenue_num
1031: AND ( nvl(pf.task_id,0) = 0
1032: OR dri.task_id = pf.task_id )

Line 1047: pa_draft_revenues dr,

1043: sum(dri.projfunc_revenue_amount) dri_projfunc_amount,dri.projfunc_currency_code,
1044: sum(dri.project_revenue_amount) dri_project_amount,dri.project_currency_code,
1045: sum(dri.funding_revenue_amount) dri_funding_amount,dri.funding_currency_code
1046: FROM pa_draft_revenue_items dri,
1047: pa_draft_revenues dr,
1048: pa_summary_project_fundings pf,
1049: pa_projects p /* Added pa_projects for bug 3647592 */
1050: WHERE dri.project_id = dr.project_id
1051: AND dri.draft_revenue_num = dr.draft_revenue_num

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