DBA Data[Home] [Help]

APPS.PA_BILLING_WORKBENCH_BILL_PKG dependencies on PA_PROJECT_CUSTOMERS

Line 136: FROM pa_project_customers pc

132: /* Modified this select for bug 3677900. This select will check how many customers are funding this project
133: */
134: SELECT count(*)
135: INTO l_count
136: FROM pa_project_customers pc
137: WHERE pc.project_id = p_project_id
138: AND EXISTS (
139: SELECT
140: spf.project_id project_id

Line 865: , pa_project_customers pc

861: -- ra_customers ra
862: hz_parties party
863: , hz_cust_accounts cust_acct
864: , pa_agreements_all agr
865: , pa_project_customers pc
866: , pa_summary_project_fundings spf
867: -- WHERE ra.customer_id = agr.customer_id
868: WHERE cust_acct.cust_account_id= agr.customer_id
869: AND cust_acct.party_id = party.party_id

Line 1071: , pa_project_customers pc

1067: -- ra_customers ra
1068: hz_parties party
1069: , hz_cust_accounts cust_acct
1070: , pa_agreements_all agr
1071: , pa_project_customers pc
1072: , pa_summary_project_fundings spf
1073: , pa_draft_invoices_all di
1074: -- WHERE ra.customer_id = agr.customer_id
1075: WHERE cust_acct.cust_account_id= agr.customer_id