APPS.PA_FUNDS_CONTROL_UTILS dependencies on GL_PERIOD_STATUSES

Line 409: ,p_set_of_books_id IN gl_period_statuses.set_of_books_id%type

405: -- ---------------------------------------------------------------------------------------------+
406: PROCEDURE get_gl_periods
407: (p_start_date IN date
408: ,p_end_date IN date
409: ,p_set_of_books_id IN gl_period_statuses.set_of_books_id%type
410: ,x_tab_count IN OUT NOCOPY Number
411: ,x_tab_pds IN OUT NOCOPY pa_funds_control_utils.tab_closed_period
412: ,x_return_status IN OUT NOCOPY varchar2
413: ) is

Line 421: FROM gl_period_statuses

417: SELECT period_name
418: ,start_date
419: ,end_date
420: ,closing_status
421: FROM gl_period_statuses
422: WHERE application_id = 101
423: AND adjustment_period_flag = 'N'
424: AND set_of_books_id = p_set_of_books_id
425: AND ( (start_date between trunc(p_start_date) and trunc(p_end_date)

Line 901: -- gl_period_statuses gps

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
905: --and gps.application_id = 101

Line 1848: GL_PERIOD_STATUSES GLS

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
1852: AND GLS.closing_status = 'C'

Line 1938: gl_period_statuses gl

1934: 'C' gl_period_status
1935: FROM pa_bc_commitments bc,
1936: pa_budget_versions pbv,
1937: pa_budget_entry_methods bem,
1938: gl_period_statuses gl
1939: WHERE GL.application_id = 101
1940: AND GL.set_of_books_id = bc.set_of_books_id
1941: AND gl.period_name = bc.period_name
1942: AND GL.closing_status = 'C'

Line 1967: gl_period_statuses gl

1963: DECODE(pbv.budget_version_id,pa_budget_fund_pkg.g_cost_prev_bvid,'C',NULL) gl_period_status
1964: from pa_bc_commitments bc,
1965: pa_budget_versions pbv,
1966: pa_budget_entry_methods bem,
1967: gl_period_statuses gl
1968: WHERE GL.application_id = 101
1969: AND GL.set_of_books_id = bc.set_of_books_id
1970: AND gl.period_name = bc.period_name
1971: AND GL.closing_status = DECODE(pbv.budget_version_id,pa_budget_fund_pkg.g_cost_prev_bvid,'C',GL.closing_status)