eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSA_BC_XML_REPORT_PUB dependencies on GL_PERIOD_STATUSES

Line 285: l_period_start_num GL_PERIOD_STATUSES.PERIOD_NUM%TYPE;

281: ) IS
282:
283: l_api_name VARCHAR2(240);
284: l_coaid GL_LEDGERS.CHART_OF_ACCOUNTS_ID%TYPE;
285: l_period_start_num GL_PERIOD_STATUSES.PERIOD_NUM%TYPE;
286: l_period_end_num GL_PERIOD_STATUSES.PERIOD_NUM%TYPE;
287: l_period_year GL_PERIOD_STATUSES.PERIOD_YEAR%TYPE; -- Bug 8966506
288: l_period_year_temp GL_PERIOD_STATUSES.PERIOD_YEAR%TYPE; -- Bug 8966506
289: l_sla_uptake_prod VARCHAR2(1);

Line 286: l_period_end_num GL_PERIOD_STATUSES.PERIOD_NUM%TYPE;

282:
283: l_api_name VARCHAR2(240);
284: l_coaid GL_LEDGERS.CHART_OF_ACCOUNTS_ID%TYPE;
285: l_period_start_num GL_PERIOD_STATUSES.PERIOD_NUM%TYPE;
286: l_period_end_num GL_PERIOD_STATUSES.PERIOD_NUM%TYPE;
287: l_period_year GL_PERIOD_STATUSES.PERIOD_YEAR%TYPE; -- Bug 8966506
288: l_period_year_temp GL_PERIOD_STATUSES.PERIOD_YEAR%TYPE; -- Bug 8966506
289: l_sla_uptake_prod VARCHAR2(1);
290: l_gl_balancing_segment NUMBER;

Line 287: l_period_year GL_PERIOD_STATUSES.PERIOD_YEAR%TYPE; -- Bug 8966506

283: l_api_name VARCHAR2(240);
284: l_coaid GL_LEDGERS.CHART_OF_ACCOUNTS_ID%TYPE;
285: l_period_start_num GL_PERIOD_STATUSES.PERIOD_NUM%TYPE;
286: l_period_end_num GL_PERIOD_STATUSES.PERIOD_NUM%TYPE;
287: l_period_year GL_PERIOD_STATUSES.PERIOD_YEAR%TYPE; -- Bug 8966506
288: l_period_year_temp GL_PERIOD_STATUSES.PERIOD_YEAR%TYPE; -- Bug 8966506
289: l_sla_uptake_prod VARCHAR2(1);
290: l_gl_balancing_segment NUMBER;
291: l_document_status VARCHAR2(1);

Line 288: l_period_year_temp GL_PERIOD_STATUSES.PERIOD_YEAR%TYPE; -- Bug 8966506

284: l_coaid GL_LEDGERS.CHART_OF_ACCOUNTS_ID%TYPE;
285: l_period_start_num GL_PERIOD_STATUSES.PERIOD_NUM%TYPE;
286: l_period_end_num GL_PERIOD_STATUSES.PERIOD_NUM%TYPE;
287: l_period_year GL_PERIOD_STATUSES.PERIOD_YEAR%TYPE; -- Bug 8966506
288: l_period_year_temp GL_PERIOD_STATUSES.PERIOD_YEAR%TYPE; -- Bug 8966506
289: l_sla_uptake_prod VARCHAR2(1);
290: l_gl_balancing_segment NUMBER;
291: l_document_status VARCHAR2(1);
292: l_meaning VARCHAR2(240);

Line 314: FROM gl_period_statuses ps

310: -- Bug 8966506 : Modified get_period_num to fetch the period_year
311: CURSOR get_period_num (p_period_name IN VARCHAR2) IS
312: SELECT period_num,
313: period_year
314: FROM gl_period_statuses ps
315: WHERE ps.ledger_id = p_para_rec.ledger_id AND
316: ps.application_id = decode(p_para_rec.application_id,
317: 200, 200,
318: 201, 201,

Line 475: GL_PERIOD_STATUSES PS

471: NULL DOCUMENT_STATUS
472: FROM
473: PSA_XLA_ACCOUNTING_ERRORS XAE,
474: PSA_BC_APPLICATION_V PBA,
475: GL_PERIOD_STATUSES PS
476: WHERE PBA.application_id = p_para_rec.application_id AND
477: XAE.ledger_id = p_para_rec.ledger_id AND
478: PS.ledger_id = p_para_rec.ledger_id AND
479: PS.application_id = p_para_rec.application_id AND

Line 2722: GL_PERIOD_STATUSES PS,

2718: MIN(PBRV.CURRENT_FUNDS_AVAILABLE),
2719: NULL
2720: BULK COLLECT INTO l_sum_dump
2721: FROM PSA_BC_RESULTS_GT PBRG,
2722: GL_PERIOD_STATUSES PS,
2723: GL_SUMMARY_TEMPLATES ST,
2724: GL_ACCOUNT_HIERARCHIES AH,
2725: GL_BUDGETS B,
2726: GL_BUDGET_VERSIONS BV,

Line 2728: GL_PERIOD_STATUSES PS2,

2724: GL_ACCOUNT_HIERARCHIES AH,
2725: GL_BUDGETS B,
2726: GL_BUDGET_VERSIONS BV,
2727: GL_SUMMARY_BC_OPTIONS SB,
2728: GL_PERIOD_STATUSES PS2,
2729: PSA_BC_REPORT_V PBRV
2730: WHERE pbrg.ccid IS NOT NULL
2731: AND ah.ledger_id = p_para_rec.ledger_id
2732: AND ah.detail_code_combination_id = PBRG.CCID

Line 2737: FROM GL_PERIOD_STATUSES P1

2733: AND ps2.ledger_id = p_para_rec.ledger_id
2734: AND ps2.application_id = 101
2735: AND PS2.period_name = pbrg.period_name
2736: AND PS2.start_date >= (SELECT P1.start_date
2737: FROM GL_PERIOD_STATUSES P1
2738: WHERE P1.application_id = ps2.application_id
2739: AND P1.ledger_id = ps2.ledger_id
2740: AND P1.period_name = B.first_valid_period_name)
2741: AND PS2.end_date <= (SELECT P2.end_date

Line 2742: FROM GL_PERIOD_STATUSES P2

2738: WHERE P1.application_id = ps2.application_id
2739: AND P1.ledger_id = ps2.ledger_id
2740: AND P1.period_name = B.first_valid_period_name)
2741: AND PS2.end_date <= (SELECT P2.end_date
2742: FROM GL_PERIOD_STATUSES P2
2743: WHERE P2.application_id = ps2.application_id
2744: AND P2.ledger_id = ps2.ledger_id
2745: AND P2.period_name = B.last_valid_period_name)
2746: AND st.status = 'F'