[Home] [Help]
210: RETURN VARCHAR2
211: IS
212: CURSOR c IS
213: SELECT closing_status, period_name, period_type
214: FROM gl_period_statuses
215: WHERE application_id = C_GL_APPLICATION_ID
216: AND ledger_id = p_ledger_id
217: AND adjustment_period_flag = 'N'
218: AND p_accounting_date BETWEEN start_date AND end_date;
428:
429: UPDATE xla_ae_headers_gt h
430: SET (period_year,period_closing_status) =
431: (SELECT period_year,closing_status
432: FROM gl_period_statuses gl
433: WHERE gl.period_name = h.period_name
434: AND gl.ledger_id = h.ledger_id
435: AND gl.application_id = 101);
436:
2958: gp.period_year > b.latest_opened_year
2959: THEN 'N'
2960: ELSE 'Y' END budget_period_valid_flag
2961: FROM xla_ae_headers h
2962: JOIN gl_period_statuses gp
2963: ON gp.period_name = h.period_name
2964: AND gp.ledger_id = g_ledger_id
2965: AND gp.application_id = C_GL_APPLICATION_ID
2966: LEFT OUTER JOIN gl_budget_versions bv
3309: ,h.gl_transfer_status_code
3310: FROM xla_ae_headers h
3311: JOIN gl_ledgers g
3312: ON g.ledger_id = h.ledger_id
3313: JOIN gl_period_statuses gp
3314: ON gp.period_name = h.period_name
3315: AND gp.ledger_id = h.ledger_id
3316: AND gp.application_id = C_GL_APPLICATION_ID
3317: LEFT OUTER JOIN gl_period_statuses rp
3313: JOIN gl_period_statuses gp
3314: ON gp.period_name = h.period_name
3315: AND gp.ledger_id = h.ledger_id
3316: AND gp.application_id = C_GL_APPLICATION_ID
3317: LEFT OUTER JOIN gl_period_statuses rp
3318: ON rp.adjustment_period_flag = 'N'
3319: AND h.reference_date BETWEEN rp.start_date AND rp.end_date
3320: AND rp.ledger_id = h.ledger_id
3321: AND rp.application_id = C_GL_APPLICATION_ID
3328: (h.balance_type_code = 'A' AND gp.closing_status NOT IN ('O', 'F')) OR
3329: (h.reference_date IS NOT NULL AND nvl(rp.closing_status,'C') NOT IN ('O', 'F')));
3330:
3331: CURSOR c_standard IS
3332: SELECT /*+ index(gp, GL_PERIOD_STATUSES_U3) */
3333: h.ae_header_id
3334: ,h.entity_id
3335: ,h.event_id
3336: ,h.accounting_date