APPS.PA_FUNDS_CONTROL_PKG dependencies on GL_PERIOD_STATUSES

Line 7223: --- GL_DATE is derived from gl_period_statuses for the given period_name and period_year

7219: x_tt_result_code := null;
7220: x_p_result_code := null;
7221: x_p_acct_result_code := null;
7222: --- document type in AP, PO, REQ, Contract Commitments and Contract Payements
7223: --- GL_DATE is derived from gl_period_statuses for the given period_name and period_year
7224: --- get end_date from gl_period_statuses based on period_name and period_num and period_year
7225: --- for document type in Expenditures
7226: --- when there is budget linked derive GL_DATE based on the Expenditure Item Date
7227: --- When there is No link then derive gl date based on the pa_periods

Line 7224: --- get end_date from gl_period_statuses based on period_name and period_num and period_year

7220: x_p_result_code := null;
7221: x_p_acct_result_code := null;
7222: --- document type in AP, PO, REQ, Contract Commitments and Contract Payements
7223: --- GL_DATE is derived from gl_period_statuses for the given period_name and period_year
7224: --- get end_date from gl_period_statuses based on period_name and period_num and period_year
7225: --- for document type in Expenditures
7226: --- when there is budget linked derive GL_DATE based on the Expenditure Item Date
7227: --- When there is No link then derive gl date based on the pa_periods
7228: IF g_debug_mode = 'Y' THEN

Line 7245: FROM gl_period_statuses gl

7241:
7242: SELECT gl.end_date,
7243: gl.start_date
7244: INTO l_gl_date,l_gl_start_date
7245: FROM gl_period_statuses gl
7246: WHERE gl.application_id = 101
7247: AND gl.set_of_books_id = p_sob_id
7248: AND gl.period_name = p_period_name
7249: AND gl.closing_status in ('O','F');

Line 7256: FROM gl_period_statuses gl

7252:
7253: SELECT gl.end_date,
7254: gl.start_date
7255: INTO l_gl_date,l_gl_start_date
7256: FROM gl_period_statuses gl
7257: WHERE gl.application_id = 101
7258: AND gl.set_of_books_id = p_sob_id
7259: AND gl.period_name = p_period_name;
7260:

Line 7306: FROM gl_period_statuses gl

7302:
7303: Elsif p_document_type = 'EXP' THEN
7304: SELECT gl.start_date
7305: INTO l_gl_start_date
7306: FROM gl_period_statuses gl
7307: WHERE gl.application_id = 101
7308: AND gl.set_of_books_id = p_sob_id
7309: AND gl.period_name = p_period_name;
7310: IF g_debug_mode = 'Y' THEN

Line 7343: FROM gl_period_statuses gl

7339: BEGIN
7340: SELECT gl.end_date,
7341: gl.start_date
7342: INTO l_gl_date,l_gl_start_date
7343: FROM gl_period_statuses gl
7344: WHERE gl.application_id = 101
7345: AND gl.set_of_books_id = p_sob_id
7346: AND gl.period_name = p_period_name;
7347: x_gl_date := l_gl_start_date;

Line 8893: FROM gl_period_statuses gl

8889: If p_mode in ('B','S') then -- Mode check
8890: Begin
8891: SELECT gl.start_date,gl.end_date
8892: INTO l_fc_start_date,l_fc_end_date
8893: FROM gl_period_statuses gl
8894: WHERE gl.application_id = 101
8895: AND gl.set_of_books_id = p_sob
8896: AND gl.period_name = g_tab_period_name(i);
8897: Exception

Line 14916: --gl_period_statuses glps

14912: pra.task_id,
14913: pbl.period_name --glps.period_name
14914: from pa_budget_lines pbl,
14915: pa_resource_assignments pra--,
14916: --gl_period_statuses glps
14917: where pra.budget_version_id = p_budget_version_id
14918: and pra.project_id = p_project_id -- added to improve performance ..
14919: and pra.budget_version_id = pbl.budget_version_id
14920: and pra.resource_assignment_id = pbl.resource_assignment_id;