[Home] [Help]
475: RETURN VARCHAR2
476: IS
477: CURSOR c IS
478: SELECT closing_status, period_name, period_type
479: FROM gl_period_statuses
480: WHERE application_id = C_GL_APPLICATION_ID
481: AND ledger_id = p_ledger_id
482: AND adjustment_period_flag = 'N'
483: AND p_accounting_date BETWEEN start_date AND end_date;
693:
694: UPDATE xla_ae_headers_gt h
695: SET (period_year,period_closing_status) =
696: (SELECT period_year,closing_status
697: FROM gl_period_statuses gl
698: WHERE gl.period_name = h.period_name
699: AND gl.ledger_id = h.ledger_id
700: AND gl.application_id = 101);
701:
3233: gp.period_year > b.latest_opened_year
3234: THEN 'N'
3235: ELSE 'Y' END budget_period_valid_flag
3236: FROM xla_ae_headers h
3237: JOIN gl_period_statuses gp
3238: ON gp.period_name = h.period_name
3239: AND gp.ledger_id = g_ledger_id
3240: AND gp.application_id = C_GL_APPLICATION_ID
3241: LEFT OUTER JOIN gl_budget_versions bv
3588: ,h.gl_transfer_status_code
3589: FROM xla_ae_headers h
3590: JOIN gl_ledgers g
3591: ON g.ledger_id = h.ledger_id
3592: JOIN gl_period_statuses gp
3593: ON gp.period_name = h.period_name
3594: AND gp.ledger_id = h.ledger_id
3595: AND gp.application_id = C_GL_APPLICATION_ID
3596: LEFT OUTER JOIN gl_period_statuses rp
3592: JOIN gl_period_statuses gp
3593: ON gp.period_name = h.period_name
3594: AND gp.ledger_id = h.ledger_id
3595: AND gp.application_id = C_GL_APPLICATION_ID
3596: LEFT OUTER JOIN gl_period_statuses rp
3597: ON rp.adjustment_period_flag = 'N'
3598: AND h.reference_date BETWEEN rp.start_date AND rp.end_date
3599: AND rp.ledger_id = h.ledger_id
3600: AND rp.application_id = C_GL_APPLICATION_ID
3607: (h.balance_type_code = 'A' AND gp.closing_status NOT IN ('O', 'F')) OR
3608: (h.reference_date IS NOT NULL AND nvl(rp.closing_status,'C') NOT IN ('O', 'F')));
3609:
3610: CURSOR c_standard IS
3611: SELECT /*+ index(gp, GL_PERIOD_STATUSES_U3) */
3612: h.ae_header_id
3613: ,h.entity_id
3614: ,h.event_id
3615: ,h.accounting_date