APPS.PA_RETN_BILLING_PKG dependencies on PA_PROJECT_CUSTOMERS

Line 262: pa_project_customers c,

258: ra_customers rc,
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

Line 273: pa_project_customers c,

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,
275: pa_projects pr,
276: hz_cust_site_uses hz_site1,
277: hz_cust_acct_sites addr

Line 330: PA_PROJECT_CUSTOMERS C

326: SELECT NULL
327: FROM PA_IMPLEMENTATIONS I
328: WHERE I.CUST_ACC_REL_CODE = 'Y'
329: AND exists ( select 1 from HZ_CUST_ACCT_RELATE HZ1,
330: PA_PROJECT_CUSTOMERS C
331: where C.PROJECT_ID=p_project_id
332: AND ( HZ1.CUST_ACCOUNT_ID(+) = C.CUSTOMER_ID
333: AND HZ1.RELATED_CUST_ACCOUNT_ID(+) = C.BILL_TO_CUSTOMER_ID
334: AND (NVL(HZ1.STATUS,'A') <>'A'

Line 343: PA_PROJECT_CUSTOMERS C

339: SELECT NULL
340: FROM PA_IMPLEMENTATIONS I
341: WHERE I.CUST_ACC_REL_CODE = 'Y'
342: AND exists ( select 1 from HZ_CUST_ACCT_RELATE HZ1,
343: PA_PROJECT_CUSTOMERS C
344: where C.PROJECT_ID=p_project_id
345: AND ( HZ1.CUST_ACCOUNT_ID(+) = C.CUSTOMER_ID
346: AND HZ1.RELATED_CUST_ACCOUNT_ID(+) = C.SHIP_TO_CUSTOMER_ID
347: AND (NVL(HZ1.STATUS,'A') <>'A'

Line 355: AND exists (select 1 from PA_PROJECT_CUSTOMERS C

351: UNION ALL
352: SELECT NULL
353: FROM PA_IMPLEMENTATIONS I
354: WHERE I.cust_acc_rel_code = 'N'
355: AND exists (select 1 from PA_PROJECT_CUSTOMERS C
356: WHERE C.PROJECT_ID = p_project_id
357: AND ( C.CUSTOMER_ID <> C.BILL_TO_CUSTOMER_ID
358: OR C.CUSTOMER_ID<>C.SHIP_TO_CUSTOMER_ID))
359:

Line 370: pa_project_customers c,

366: INTO TmpBilltocontactid,
367: TmpShiptocontactid
368: FROM pa_project_contacts projcon,
369: pa_project_contacts cont,
370: pa_project_customers c,
371: hz_role_responsibility role,
372: /* TCA changes
373: ra_contact_roles role,
374: */

Line 392: FROM PA_PROJECT_CUSTOMERS c1

388: */
389: and role.cust_account_role_id (+) = CONT.Contact_ID
390: and role.responsibility_type (+) = 'SHIP_TO'
391: and NOT EXISTS (SELECT NULL
392: FROM PA_PROJECT_CUSTOMERS c1
393: WHERE c1.project_id=p_project_id
394: AND NOT EXISTS
395: (
396: SELECT NULL

Line 1283: FROM pa_project_customers pc, pa_projects_all pr, ra_customers c

1279: pc.customer_id customer_id,
1280: pc.retention_level_code retention_level,
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,

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