DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_PKG dependencies on GL_PERIOD_STATUSES

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

7042: x_tt_result_code := null;
7043: x_p_result_code := null;
7044: x_p_acct_result_code := null;
7045: --- document type in AP, PO, REQ, Contract Commitments and Contract Payements
7046: --- GL_DATE is derived from gl_period_statuses for the given period_name and period_year
7047: --- get end_date from gl_period_statuses based on period_name and period_num and period_year
7048: --- for document type in Expenditures
7049: --- when there is budget linked derive GL_DATE based on the Expenditure Item Date
7050: --- When there is No link then derive gl date based on the pa_periods

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

7043: x_p_result_code := null;
7044: x_p_acct_result_code := null;
7045: --- document type in AP, PO, REQ, Contract Commitments and Contract Payements
7046: --- GL_DATE is derived from gl_period_statuses for the given period_name and period_year
7047: --- get end_date from gl_period_statuses based on period_name and period_num and period_year
7048: --- for document type in Expenditures
7049: --- when there is budget linked derive GL_DATE based on the Expenditure Item Date
7050: --- When there is No link then derive gl date based on the pa_periods
7051: IF g_debug_mode = 'Y' THEN

Line 7064: FROM gl_period_statuses gl

7060: End if;
7061: SELECT gl.end_date,
7062: gl.start_date
7063: INTO l_gl_date,l_gl_start_date
7064: FROM gl_period_statuses gl
7065: WHERE gl.application_id = 101
7066: AND gl.set_of_books_id = p_sob_id
7067: AND gl.period_name = p_period_name
7068: AND gl.closing_status in ('O','F');

Line 7111: FROM gl_period_statuses gl

7107:
7108: Elsif p_document_type = 'EXP' THEN
7109: SELECT gl.start_date
7110: INTO l_gl_start_date
7111: FROM gl_period_statuses gl
7112: WHERE gl.application_id = 101
7113: AND gl.set_of_books_id = p_sob_id
7114: AND gl.period_name = p_period_name;
7115: IF g_debug_mode = 'Y' THEN

Line 7148: FROM gl_period_statuses gl

7144: BEGIN
7145: SELECT gl.end_date,
7146: gl.start_date
7147: INTO l_gl_date,l_gl_start_date
7148: FROM gl_period_statuses gl
7149: WHERE gl.application_id = 101
7150: AND gl.set_of_books_id = p_sob_id
7151: AND gl.period_name = p_period_name;
7152: x_gl_date := l_gl_start_date;

Line 8659: FROM gl_period_statuses gl

8655: If p_mode in ('B','S') then -- Mode check
8656: Begin
8657: SELECT gl.start_date,gl.end_date
8658: INTO l_fc_start_date,l_fc_end_date
8659: FROM gl_period_statuses gl
8660: WHERE gl.application_id = 101
8661: AND gl.set_of_books_id = p_sob
8662: AND gl.period_name = g_tab_period_name(i);
8663: Exception

Line 14494: --gl_period_statuses glps

14490: pra.task_id,
14491: pbl.period_name --glps.period_name
14492: from pa_budget_lines pbl,
14493: pa_resource_assignments pra--,
14494: --gl_period_statuses glps
14495: where pra.budget_version_id = p_budget_version_id
14496: and pra.project_id = p_project_id -- added to improve performance ..
14497: and pra.budget_version_id = pbl.budget_version_id
14498: and pra.resource_assignment_id = pbl.resource_assignment_id;