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_sla_uptake_prod VARCHAR2(1);
288: l_gl_balancing_segment NUMBER;
289: l_document_status 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_sla_uptake_prod VARCHAR2(1);
288: l_gl_balancing_segment NUMBER;
289: l_document_status VARCHAR2(1);
290: l_meaning VARCHAR2(240);

Line 299: FROM gl_period_statuses ps

295: WHERE ledger_id = p_ledgerid;
296:
297: CURSOR get_period_num (p_period_name IN VARCHAR2) IS
298: SELECT period_num
299: FROM gl_period_statuses ps
300: WHERE ps.ledger_id = p_para_rec.ledger_id AND
301: ps.application_id = decode(p_para_rec.application_id,
302: 200, 200,
303: 201, 201,

Line 458: GL_PERIOD_STATUSES PS

454: NULL CURRENT_FUNDS_AVAILABLE,
455: NULL DOCUMENT_STATUS
456: FROM PSA_BC_ACCOUNTING_ERRORS PAE,
457: PSA_BC_APPLICATION_V PBA,
458: GL_PERIOD_STATUSES PS
459: WHERE PBA.application_id = p_para_rec.application_id AND
460: PAE.ledger_id = p_para_rec.ledger_id AND
461: PS.ledger_id = p_para_rec.ledger_id AND
462: PS.application_id = p_para_rec.application_id AND

Line 2649: GL_PERIOD_STATUSES PS,

2645: MIN(PBRV.CURRENT_FUNDS_AVAILABLE),
2646: NULL
2647: BULK COLLECT INTO l_sum_dump
2648: FROM PSA_BC_RESULTS_GT PBRG,
2649: GL_PERIOD_STATUSES PS,
2650: GL_SUMMARY_TEMPLATES ST,
2651: GL_ACCOUNT_HIERARCHIES AH,
2652: GL_BUDGETS B,
2653: GL_BUDGET_VERSIONS BV,

Line 2655: GL_PERIOD_STATUSES PS2,

2651: GL_ACCOUNT_HIERARCHIES AH,
2652: GL_BUDGETS B,
2653: GL_BUDGET_VERSIONS BV,
2654: GL_SUMMARY_BC_OPTIONS SB,
2655: GL_PERIOD_STATUSES PS2,
2656: PSA_BC_REPORT_V PBRV
2657: WHERE pbrg.ccid IS NOT NULL
2658: AND ah.ledger_id = p_para_rec.ledger_id
2659: AND ah.detail_code_combination_id = PBRG.CCID

Line 2664: FROM GL_PERIOD_STATUSES P1

2660: AND ps2.ledger_id = p_para_rec.ledger_id
2661: AND ps2.application_id = 101
2662: AND PS2.period_name = pbrg.period_name
2663: AND PS2.start_date >= (SELECT P1.start_date
2664: FROM GL_PERIOD_STATUSES P1
2665: WHERE P1.application_id = ps2.application_id
2666: AND P1.ledger_id = ps2.ledger_id
2667: AND P1.period_name = B.first_valid_period_name)
2668: AND PS2.end_date <= (SELECT P2.end_date

Line 2669: FROM GL_PERIOD_STATUSES P2

2665: WHERE P1.application_id = ps2.application_id
2666: AND P1.ledger_id = ps2.ledger_id
2667: AND P1.period_name = B.first_valid_period_name)
2668: AND PS2.end_date <= (SELECT P2.end_date
2669: FROM GL_PERIOD_STATUSES P2
2670: WHERE P2.application_id = ps2.application_id
2671: AND P2.ledger_id = ps2.ledger_id
2672: AND P2.period_name = B.last_valid_period_name)
2673: AND st.status = 'F'