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 924: , pa_summary_project_fundings spf

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

Line 1139: , pa_summary_project_fundings spf

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