APPS.PA_FUNDS_CONTROL_UTILS dependencies on GL_PERIOD_STATUSES

Line 482: ,p_set_of_books_id IN gl_period_statuses.set_of_books_id%type

478: -- ---------------------------------------------------------------------------------------------+
479: PROCEDURE get_gl_periods
480: (p_start_date IN date
481: ,p_end_date IN date
482: ,p_set_of_books_id IN gl_period_statuses.set_of_books_id%type
483: ,x_tab_count IN OUT NOCOPY Number
484: ,x_tab_pds IN OUT NOCOPY pa_funds_control_utils.tab_closed_period
485: ,x_return_status IN OUT NOCOPY varchar2
486: ) is

Line 494: FROM gl_period_statuses

490: SELECT period_name
491: ,start_date
492: ,end_date
493: ,closing_status
494: FROM gl_period_statuses
495: WHERE application_id = 101
496: AND adjustment_period_flag = 'N'
497: AND set_of_books_id = p_set_of_books_id
498: AND ( (start_date between trunc(p_start_date) and trunc(p_end_date)

Line 1052: -- gl_period_statuses gps

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

Line 1999: GL_PERIOD_STATUSES GLS

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

Line 2089: gl_period_statuses gl

2085: 'C' gl_period_status
2086: FROM pa_bc_commitments bc,
2087: pa_budget_versions pbv,
2088: pa_budget_entry_methods bem,
2089: gl_period_statuses gl
2090: WHERE GL.application_id = 101
2091: AND GL.set_of_books_id = bc.set_of_books_id
2092: AND gl.period_name = bc.period_name
2093: AND GL.closing_status = 'C'

Line 2118: gl_period_statuses gl

2114: DECODE(pbv.budget_version_id,pa_budget_fund_pkg.g_cost_prev_bvid,'C',NULL) gl_period_status
2115: from pa_bc_commitments bc,
2116: pa_budget_versions pbv,
2117: pa_budget_entry_methods bem,
2118: gl_period_statuses gl
2119: WHERE GL.application_id = 101
2120: AND GL.set_of_books_id = bc.set_of_books_id
2121: AND gl.period_name = bc.period_name
2122: AND GL.closing_status = DECODE(pbv.budget_version_id,pa_budget_fund_pkg.g_cost_prev_bvid,'C',GL.closing_status)