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_AGREEMENTS

Line 995: AND exists (select 1 from pa_agreements paa where paa.agreement_id = pf.agreement_id

991: AND dr.project_id+0 = pf.project_id
992: AND dr.agreement_id = pf.agreement_id
993: AND pf.project_id = l_project_id
994: AND p.project_id = pf.project_id
995: AND exists (select 1 from pa_agreements paa where paa.agreement_id = pf.agreement_id
996: and dri.funding_currency_code = paa.agreement_currency_code) /* condition added for Bug 5956273*/
997:
998: GROUP BY pf.agreement_id, pf.project_id, decode(p.project_level_funding_flag,'Y',0,pf.task_id),dri.revproc_currency_code,
999: dri.projfunc_currency_code,dri.project_currency_code,

Line 1048: AND exists (select 1 from pa_agreements paa where paa.agreement_id = pf.agreement_id

1044: AND di.agreement_id = pf.agreement_id
1045: AND nvl(pf.task_id, 0) = 0
1046: AND pf.project_id = l_project_id
1047: AND pf.total_baselined_amount > 0 /* 2094391 */
1048: AND exists (select 1 from pa_agreements paa where paa.agreement_id = pf.agreement_id
1049: and dii.funding_currency_code = paa.agreement_currency_code) /* condition added for Bug 5956273*/
1050: GROUP BY pf.agreement_id, pf.project_id
1051: ,dii.invproc_currency_code,dii.projfunc_currency_code,dii.project_currency_code
1052: , dii.funding_currency_code; /* MCB related changes */

Line 1082: AND exists (select 1 from pa_agreements paa where paa.agreement_id = pf.agreement_id

1078: AND di.agreement_id = pf.agreement_id
1079: AND pf.project_id = l_project_id
1080: AND pf.project_id = dii.project_id /* Bug#5081194 : added this condition */
1081: AND pf.total_baselined_amount > 0 /* added for bug 3464050 */
1082: AND exists (select 1 from pa_agreements paa where paa.agreement_id = pf.agreement_id
1083: and dii.funding_currency_code = paa.agreement_currency_code) /* condition added for Bug 5956273*/
1084: GROUP BY pf.agreement_id, pf.project_id, pf.task_id
1085: ,dii.invproc_currency_code,dii.projfunc_currency_code,
1086: dii.project_currency_code,dii.funding_currency_code; /* MCB related changes */