APPS.PA_FUNDS_CONTROL_UTILS dependencies on PA_BUDGET_ACCT_LINES

Line 1035: --from PA_BUDGET_ACCT_LINES

1031: END Get_Baselined_Budget_Version;
1032:
1033: -- --------------------------------------------------------------------------------------------------+
1034: --The following API returns the available balance for the budget_version, budget_CCID and start_date
1035: --from PA_BUDGET_ACCT_LINES
1036: -- --------------------------------------------------------------------------------------------------+
1037: FUNCTION Get_Acct_Line_Balance(
1038: p_budget_version_id in number,
1039: p_start_date in date,

Line 1051: --from pa_budget_acct_lines bal,

1047: END IF;
1048: /*
1049: --select bal.Curr_Ver_Available_Amount
1050: --into x_avail_balance
1051: --from pa_budget_acct_lines bal,
1052: -- gl_period_statuses gps
1053: --where trunc(gps.start_date) = trunc(p_start_date)
1054: --and trunc(gps.end_date) = trunc(p_end_date)
1055: --and gps.period_name = bal.gl_period_name

Line 1067: FROM pa_budget_acct_lines bal

1063: */
1064:
1065: SELECT sum(nvl(bal.Curr_Ver_Available_Amount,0))
1066: INTO x_avail_balance
1067: FROM pa_budget_acct_lines bal
1068: WHERE bal.budget_version_id = p_budget_version_id
1069: AND bal.code_combination_id = p_budget_ccid
1070: AND start_date between trunc(p_start_date) and trunc(p_end_date)
1071: AND end_date between trunc(p_start_date) and trunc(p_end_date);

Line 1998: FROM PA_BUDGET_ACCT_LINES PBA,

1994: RETURN VARCHAR2 IS
1995:
1996: CURSOR c_closed_periods_exists IS
1997: SELECT 'Y'
1998: FROM PA_BUDGET_ACCT_LINES PBA,
1999: GL_PERIOD_STATUSES GLS
2000: WHERE GLS.application_id = 101
2001: AND GLS.set_of_books_id in (SELECT set_of_books_id FROM pa_implementations)
2002: AND GLS.period_name = PBA.gl_period_name