APPS.PA_BILLING_WORKBENCH_BILL_PKG dependencies on PA_SUMMARY_PROJECT_FUNDINGS

Line 145: , pa_summary_project_fundings spf

141: ,spf.agreement_id
142: ,agr.customer_id customer_id
143: FROM
144: pa_agreements_all agr
145: , pa_summary_project_fundings spf
146: WHERE agr.customer_id = pc.customer_id
147: AND agr.agreement_id = spf.agreement_id
148: AND spf.project_id = pc.project_id
149: AND spf.project_id = p_project_id

Line 199: FROM pa_summary_project_fundings spf

195: l_projfunc_rev_accured ,
196: l_projfunc_rev_backlog ,
197: l_projfunc_inv_invoiced ,
198: l_projfunc_inv_backlog
199: FROM pa_summary_project_fundings spf
200: WHERE spf.project_id = p_project_id;
201:
202: /* Unbilled Receivable, and Unearned Revenue in Project and
203: Project Functional Currency for Revenue Section */

Line 866: , pa_summary_project_fundings spf

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
870: AND agr.customer_id = pc.customer_id

Line 1072: , pa_summary_project_fundings spf

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
1076: AND cust_acct.party_id = party.party_id