APPS.PA_RETN_BILLING_PKG dependencies on HZ_CUST_ACCOUNTS

Line 269: hz_cust_accounts hz_c,

265: ra_site_uses ras1,
266: ra_addresses addr
267: */
268: from hz_customer_profiles hz_cp1,
269: hz_cust_accounts hz_c,
270: hz_cust_accounts hz_c1,
271: hz_customer_profiles hz_cp,
272: hz_cust_site_uses hz_site,
273: pa_project_customers c,

Line 270: hz_cust_accounts hz_c1,

266: ra_addresses addr
267: */
268: from hz_customer_profiles hz_cp1,
269: hz_cust_accounts hz_c,
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,

Line 1285: FROM pa_project_customers pc, pa_projects_all pr, hz_parties hz_p, hz_cust_accounts hz_c

1281: NVL(pr.RETN_BILLING_INV_FORMAT_ID,0) RETN_BILLING_INV_FORMAT_ID
1282: /* TCA changes
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