14601: Cursor c_gl_records is
14602: select glbc.rowid,glbc.ae_header_id,glbc.ledger_id
14603: from gl_bc_packets glbc
14604: where glbc.event_id in
14605: (select event_id from psa_bc_xla_events_gt);
14606:
14607: l_dummy_value number(1);
14608:
14609: Begin
16436: Cursor c_gl_records is
16437: select glbc.rowid,glbc.ae_header_id,glbc.ledger_id
16438: from gl_bc_packets glbc
16439: where glbc.event_id in
16440: (select event_id from psa_bc_xla_events_gt);
16441:
16442: l_baseline_failed Varchar2(1);
16443: t_ae_header_id TypeNum;
16444: t_ledger_id TypeNum;
16460: where exists
16461: (select packet_id
16462: from gl_bc_packets glbc
16463: where glbc.event_id in
16464: (select event_id from psa_bc_xla_events_gt)
16465: and glbc.result_code like 'F%');
16466: Exception
16467: when no_data_found then
16468: l_baseline_failed := 'N';