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_RETN_BILLING_PKG dependencies on PA_SUMMARY_PROJECT_RETN

Line 1287: SELECT NULL FROM pa_summary_project_retn spr,

1283: FROM pa_project_customers pc, pa_projects_all pr, ra_customers c
1284: */
1285: FROM pa_project_customers pc, pa_projects_all pr, hz_parties hz_p, hz_cust_accounts hz_c
1286: WHERE EXISTS(
1287: SELECT NULL FROM pa_summary_project_retn spr,
1288: pa_proj_retn_bill_rules rt
1289: WHERE rt.project_id = spr.project_id
1290: AND rt.customer_id = spr.customer_id
1291: AND spr.customer_id = pc.customer_id

Line 1403: FROM pa_summary_project_retn spr,

1399: spr.funding_currency_code,
1400: spr.funding_total_retained,
1401: (NVL(spr.total_retained,0)- NVL(spr.total_billed,0)) Remain_Retained_Amt,
1402: pr.inv_by_bill_trans_curr_flag inv_by_bill_trans_curr_flag
1403: FROM pa_summary_project_retn spr,
1404: pa_agreements_all agr,
1405: pa_projects_all pr
1406: WHERE agr.agreement_id = spr.agreement_id
1407: AND agr.customer_id = TmpCustomerID

Line 1513: FROM pa_summary_project_retn spr

1509:
1510: SELECT SUM(NVL(spr.total_retained,0)) -
1511: SUM(NVL(spr.total_billed,0))
1512: INTO CurRetained
1513: FROM pa_summary_project_retn spr
1514: WHERE spr.project_id= TmpProjectId
1515: AND spr.customer_id= TmpCustomerId; /*Added for bug 3234999*/
1516:
1517: IF g1_debug_mode = 'Y' THEN

Line 1526: FROM pa_summary_project_retn spr

1522:
1523: SELECT SUM(NVL(spr.total_retained,0)) -
1524: SUM(NVL(spr.total_billed,0))
1525: INTO CurRetained
1526: FROM pa_summary_project_retn spr
1527: WHERE spr.project_id= TmpProjectId
1528: AND spr.task_id = NewTask
1529: AND spr.customer_id= TmpCustomerId; /*Added for bug 3234999*/
1530: