DBA Data[Home] [Help]

APPS.PA_FUND_REVAL_PVT dependencies on PA_AGREEMENTS_ALL

Line 1722: FROM pa_summary_project_fundings SPF, pa_agreements_all A, pa_project_customers PC

1718: SPF.projfunc_accrued_amount projfunc_accrued_amount,
1719: SPF.invproc_billed_amount invproc_billed_amount,
1720: PC.retention_level_code retention_level_code,
1721: PC.customer_id customer_id
1722: FROM pa_summary_project_fundings SPF, pa_agreements_all A, pa_project_customers PC
1723: WHERE SPF.project_id = l_ProjectId
1724: AND A.agreement_id = SPF.agreement_id
1725: AND PC.customer_id = A.customer_id
1726: AND PC.project_id = SPF.project_id

Line 1755: FROM pa_summary_project_fundings SPF, pa_agreements_all A, pa_project_customers PC

1751: SPF.projfunc_accrued_amount projfunc_accrued_amount,
1752: SPF.invproc_billed_amount invproc_billed_amount,
1753: PC.retention_level_code retention_level_code,
1754: PC.customer_id cust_id
1755: FROM pa_summary_project_fundings SPF, pa_agreements_all A, pa_project_customers PC
1756: WHERE SPF.project_id = l_ProjectId
1757: AND A.agreement_id = SPF.agreement_id
1758: AND PC.customer_id = A.customer_id
1759: AND PC.project_id = SPF.project_id

Line 1779: pa_agreements_all A, pa_project_customers PC,

1775: SPF.invproc_billed_amount invproc_billed_amount,
1776: PC.retention_level_code retention_level_code,
1777: PC.customer_id cust_id
1778: FROM pa_mc_sum_proj_fundings SPF_mc, pa_summary_project_fundings SPF,
1779: pa_agreements_all A, pa_project_customers PC,
1780: gl_alc_ledger_rships_v rep, pa_implementations imp
1781: WHERE SPF.project_id = l_ProjectId
1782: AND A.agreement_id = SPF.agreement_id
1783: AND PC.customer_id = A.customer_id