APPS.PA_RETN_BILLING_PKG dependencies on PA_PROJECT_CONTACTS

Line 368: FROM pa_project_contacts projcon,

364: -1, decode(MIN(CONT.Contact_ID), 0, NULL, MIN(CONT.Contact_ID)),
365: MAX(decode(ROLE.Primary_Flag, 'Y', CONT.Contact_ID, -1)))
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

Line 369: pa_project_contacts cont,

365: MAX(decode(ROLE.Primary_Flag, 'Y', CONT.Contact_ID, -1)))
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,

Line 397: FROM pa_project_contacts projcon

393: WHERE c1.project_id=p_project_id
394: AND NOT EXISTS
395: (
396: SELECT NULL
397: FROM pa_project_contacts projcon
398: WHERE projcon.project_contact_type_code = 'BILLING'
399: AND projcon.customer_id =c1.customer_id
400: AND projcon.project_ID = c1.project_id)
401: );