APPS.PA_RETN_BILLING_PKG dependencies on PA_AGREEMENTS_ALL

Line 263: pa_agreements_all a,

259: ra_customers rc1, --Added for customer account relation
260: ar_customer_profiles cp,
261: ra_site_uses ras,
262: pa_project_customers c,
263: pa_agreements_all a,
264: pa_projects pr,
265: ra_site_uses ras1,
266: ra_addresses addr
267: */

Line 274: pa_agreements_all a,

270: hz_cust_accounts hz_c1,
271: hz_customer_profiles hz_cp,
272: hz_cust_site_uses hz_site,
273: pa_project_customers c,
274: pa_agreements_all a,
275: pa_projects pr,
276: hz_cust_site_uses hz_site1,
277: hz_cust_acct_sites addr
278: where a.agreement_id = p_agreement_id

Line 375: pa_agreements_all a /*Added for bug2984282*/

371: hz_role_responsibility role,
372: /* TCA changes
373: ra_contact_roles role,
374: */
375: pa_agreements_all a /*Added for bug2984282*/
376: WHERE c.project_id=p_project_id
377: and a.agreement_id=p_agreement_id
378: and c.customer_id=p_customer_id/*Added for bug 2984282*/
379: and projcon.project_contact_type_code = 'BILLING'

Line 1404: pa_agreements_all agr,

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
1408: AND spr.project_id = TmpProjectId