APPS.PA_BILLING dependencies on PA_AGREEMENTS_ALL

Line 1058: AND exists (select 1 from pa_agreements_all paa where paa.agreement_id = pf.agreement_id /*Changed to pa_agreements_all for bug 8307812 */

1054: AND dr.project_id+0 = pf.project_id
1055: AND dr.agreement_id = pf.agreement_id
1056: AND pf.project_id = l_project_id
1057: AND p.project_id = pf.project_id
1058: AND exists (select 1 from pa_agreements_all paa where paa.agreement_id = pf.agreement_id /*Changed to pa_agreements_all for bug 8307812 */
1059: and dri.funding_currency_code = paa.agreement_currency_code) /* condition added for Bug 5956273*/
1060:
1061: GROUP BY pf.agreement_id, pf.project_id, decode(p.project_level_funding_flag,'Y',0,pf.task_id),dri.revproc_currency_code,
1062: dri.projfunc_currency_code,dri.project_currency_code,

Line 1114: AND exists (select 1 from pa_agreements_all paa where paa.agreement_id = pf.agreement_id /*Changed to pa_agreements_all for bug 8307812 */

1110: AND pf.invproc_currency_code = dii.invproc_currency_code /* Added for Bug 9402708 */
1111: AND l_project_level_funding_flag = 'Y' /* added for bug 9649164 */
1112: AND dii.invproc_currency_code = pf.invproc_currency_code /* Added for bug 14196309 */
1113: /* AND pf.total_baselined_amount > 0 *//* 2094391 *//* commented for bug 9649164 */
1114: AND exists (select 1 from pa_agreements_all paa where paa.agreement_id = pf.agreement_id /*Changed to pa_agreements_all for bug 8307812 */
1115: and dii.funding_currency_code = paa.agreement_currency_code) /* condition added for Bug 5956273*/
1116: GROUP BY pf.agreement_id, pf.project_id
1117: ,dii.invproc_currency_code,dii.projfunc_currency_code,dii.project_currency_code
1118: , dii.funding_currency_code; /* MCB related changes */

Line 1151: AND exists (select 1 from pa_agreements_all paa where paa.agreement_id = pf.agreement_id /*Changed to pa_agreements_all for bug 8307812 */

1147: AND pf.invproc_currency_code = dii.invproc_currency_code /* Added for Bug 9402708 */
1148: AND l_project_level_funding_flag = 'N' /* added for bug 9649164 */
1149: /* AND pf.total_baselined_amount > 0 *//* added for bug 3464050 *//* commented for bug 9649164 */
1150: AND dii.invproc_currency_code = pf.invproc_currency_code /* Added for bug 14196309 */
1151: AND exists (select 1 from pa_agreements_all paa where paa.agreement_id = pf.agreement_id /*Changed to pa_agreements_all for bug 8307812 */
1152: and dii.funding_currency_code = paa.agreement_currency_code) /* condition added for Bug 5956273*/
1153: GROUP BY pf.agreement_id, pf.project_id, pf.task_id
1154: ,dii.invproc_currency_code,dii.projfunc_currency_code,
1155: dii.project_currency_code,dii.funding_currency_code; /* MCB related changes */