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 923: , pa_project_customers pc

919: -- ra_customers ra
920: hz_parties party
921: , hz_cust_accounts cust_acct
922: , pa_agreements_all agr
923: , pa_project_customers pc
924: , pa_summary_project_fundings spf
925: -- WHERE ra.customer_id = agr.customer_id
926: WHERE cust_acct.cust_account_id= agr.customer_id
927: AND cust_acct.party_id = party.party_id

Line 1138: , pa_project_customers pc

1134: -- ra_customers ra
1135: hz_parties party
1136: , hz_cust_accounts cust_acct
1137: , pa_agreements_all agr
1138: , pa_project_customers pc
1139: , pa_summary_project_fundings spf
1140: , pa_draft_invoices_all di
1141: -- WHERE ra.customer_id = agr.customer_id
1142: WHERE cust_acct.cust_account_id= agr.customer_id