APPS.PA_FUNDS_CONTROL_UTILS dependencies on PA_BUDGET_ACCT_LINES

Line 884: --from PA_BUDGET_ACCT_LINES

880: END Get_Baselined_Budget_Version;
881:
882: -- --------------------------------------------------------------------------------------------------+
883: --The following API returns the available balance for the budget_version, budget_CCID and start_date
884: --from PA_BUDGET_ACCT_LINES
885: -- --------------------------------------------------------------------------------------------------+
886: FUNCTION Get_Acct_Line_Balance(
887: p_budget_version_id in number,
888: p_start_date in date,

Line 900: --from pa_budget_acct_lines bal,

896: END IF;
897: /*
898: --select bal.Curr_Ver_Available_Amount
899: --into x_avail_balance
900: --from pa_budget_acct_lines bal,
901: -- gl_period_statuses gps
902: --where trunc(gps.start_date) = trunc(p_start_date)
903: --and trunc(gps.end_date) = trunc(p_end_date)
904: --and gps.period_name = bal.gl_period_name

Line 916: FROM pa_budget_acct_lines bal

912: */
913:
914: SELECT sum(nvl(bal.Curr_Ver_Available_Amount,0))
915: INTO x_avail_balance
916: FROM pa_budget_acct_lines bal
917: WHERE bal.budget_version_id = p_budget_version_id
918: AND bal.code_combination_id = p_budget_ccid
919: AND start_date between trunc(p_start_date) and trunc(p_end_date)
920: AND end_date between trunc(p_start_date) and trunc(p_end_date);

Line 1847: FROM PA_BUDGET_ACCT_LINES PBA,

1843: RETURN VARCHAR2 IS
1844:
1845: CURSOR c_closed_periods_exists IS
1846: SELECT 'Y'
1847: FROM PA_BUDGET_ACCT_LINES PBA,
1848: GL_PERIOD_STATUSES GLS
1849: WHERE GLS.application_id = 101
1850: AND GLS.set_of_books_id in (SELECT set_of_books_id FROM pa_implementations)
1851: AND GLS.period_name = PBA.gl_period_name