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 168: (select NULL from pa_draft_revenues pdr

164: )
165: or
166: ( x_calling_process in ('Revenue','Both')
167: AND EXISTS
168: (select NULL from pa_draft_revenues pdr
169: where pdr.project_id = x_project_id
170: and pdr.request_id = x_request_id
171: and (( x_calling_place = 'ADJ'
172: and pdr.draft_revenue_num_credited is not null)

Line 965: pa_draft_revenues dr

961: AND pf.project_id = l_project_id
962: AND NOT EXISTS
963: ( SELECT null
964: FROM pa_draft_revenue_items dri,
965: pa_draft_revenues dr
966: WHERE dri.project_id = dr.project_id
967: AND dri.draft_revenue_num = dr.draft_revenue_num
968: AND ( nvl(pf.task_id,0) = 0
969: OR dri.task_id = pf.task_id )

Line 984: pa_draft_revenues dr,

980: sum(dri.projfunc_revenue_amount) dri_projfunc_amount,dri.projfunc_currency_code,
981: sum(dri.project_revenue_amount) dri_project_amount,dri.project_currency_code,
982: sum(dri.funding_revenue_amount) dri_funding_amount,dri.funding_currency_code
983: FROM pa_draft_revenue_items dri,
984: pa_draft_revenues dr,
985: pa_summary_project_fundings pf,
986: pa_projects p /* Added pa_projects for bug 3647592 */
987: WHERE dri.project_id = dr.project_id
988: AND dri.draft_revenue_num = dr.draft_revenue_num

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