APPS.IGI_IAC_EXTRACT_PKG dependencies on FA_XLA_EXT_HEADERS_B_GT

Line 120: INSERT INTO FA_XLA_EXT_HEADERS_B_GT (

116:
117: for i in all_events loop
118: --Extract Fa transaction header object
119: for j in fa_header(i.event_id,i.source_id_int_1,i.valuation_method) loop
120: INSERT INTO FA_XLA_EXT_HEADERS_B_GT (
121: event_id ,
122: BOOK_TYPE_CODE ,
123: BOOK_DESCRIPTION ,
124: ORG_ID ,

Line 256: delete from FA_XLA_EXT_HEADERS_B_GT_tmp;

252: /*delete from igi_iac_xla_lines_gt_tmp;
253: insert into igi_iac_xla_lines_gt_tmp
254: select * from igi_iac_xla_lines_gt;
255:
256: delete from FA_XLA_EXT_HEADERS_B_GT_tmp;
257: insert into FA_XLA_EXT_HEADERS_B_GT_tmp
258: select * from FA_XLA_EXT_HEADERS_B_GT;
259:
260: delete from FA_XLA_EXT_LINES_B_GT_tmp;

Line 257: insert into FA_XLA_EXT_HEADERS_B_GT_tmp

253: insert into igi_iac_xla_lines_gt_tmp
254: select * from igi_iac_xla_lines_gt;
255:
256: delete from FA_XLA_EXT_HEADERS_B_GT_tmp;
257: insert into FA_XLA_EXT_HEADERS_B_GT_tmp
258: select * from FA_XLA_EXT_HEADERS_B_GT;
259:
260: delete from FA_XLA_EXT_LINES_B_GT_tmp;
261: INSERT INTO FA_XLA_EXT_LINES_B_GT_tmp

Line 258: select * from FA_XLA_EXT_HEADERS_B_GT;

254: select * from igi_iac_xla_lines_gt;
255:
256: delete from FA_XLA_EXT_HEADERS_B_GT_tmp;
257: insert into FA_XLA_EXT_HEADERS_B_GT_tmp
258: select * from FA_XLA_EXT_HEADERS_B_GT;
259:
260: delete from FA_XLA_EXT_LINES_B_GT_tmp;
261: INSERT INTO FA_XLA_EXT_LINES_B_GT_tmp
262: select * from FA_XLA_EXT_LINES_B_GT;*/

Line 526: delete from FA_XLA_EXT_HEADERS_B_GT_tmp;

522: /* delete from igi_iac_xla_lines_gt_tmp;
523: insert into igi_iac_xla_lines_gt_tmp
524: select * from igi_iac_xla_lines_gt;
525:
526: delete from FA_XLA_EXT_HEADERS_B_GT_tmp;
527: insert into FA_XLA_EXT_HEADERS_B_GT_tmp
528: select * from FA_XLA_EXT_HEADERS_B_GT;
529:
530: delete from FA_XLA_EXT_LINES_B_GT_tmp;

Line 527: insert into FA_XLA_EXT_HEADERS_B_GT_tmp

523: insert into igi_iac_xla_lines_gt_tmp
524: select * from igi_iac_xla_lines_gt;
525:
526: delete from FA_XLA_EXT_HEADERS_B_GT_tmp;
527: insert into FA_XLA_EXT_HEADERS_B_GT_tmp
528: select * from FA_XLA_EXT_HEADERS_B_GT;
529:
530: delete from FA_XLA_EXT_LINES_B_GT_tmp;
531: INSERT INTO FA_XLA_EXT_LINES_B_GT_tmp

Line 528: select * from FA_XLA_EXT_HEADERS_B_GT;

524: select * from igi_iac_xla_lines_gt;
525:
526: delete from FA_XLA_EXT_HEADERS_B_GT_tmp;
527: insert into FA_XLA_EXT_HEADERS_B_GT_tmp
528: select * from FA_XLA_EXT_HEADERS_B_GT;
529:
530: delete from FA_XLA_EXT_LINES_B_GT_tmp;
531: INSERT INTO FA_XLA_EXT_LINES_B_GT_tmp
532: select * from FA_XLA_EXT_LINES_B_GT;*/

Line 659: delete from FA_XLA_EXT_HEADERS_B_GT_tmp;

655: /* delete from igi_iac_xla_lines_gt_tmp;
656: insert into igi_iac_xla_lines_gt_tmp
657: select * from igi_iac_xla_lines_gt;
658:
659: delete from FA_XLA_EXT_HEADERS_B_GT_tmp;
660: insert into FA_XLA_EXT_HEADERS_B_GT_tmp
661: select * from FA_XLA_EXT_HEADERS_B_GT;
662:
663: delete from FA_XLA_EXT_LINES_B_GT_tmp;

Line 660: insert into FA_XLA_EXT_HEADERS_B_GT_tmp

656: insert into igi_iac_xla_lines_gt_tmp
657: select * from igi_iac_xla_lines_gt;
658:
659: delete from FA_XLA_EXT_HEADERS_B_GT_tmp;
660: insert into FA_XLA_EXT_HEADERS_B_GT_tmp
661: select * from FA_XLA_EXT_HEADERS_B_GT;
662:
663: delete from FA_XLA_EXT_LINES_B_GT_tmp;
664: INSERT INTO FA_XLA_EXT_LINES_B_GT_tmp

Line 661: select * from FA_XLA_EXT_HEADERS_B_GT;

657: select * from igi_iac_xla_lines_gt;
658:
659: delete from FA_XLA_EXT_HEADERS_B_GT_tmp;
660: insert into FA_XLA_EXT_HEADERS_B_GT_tmp
661: select * from FA_XLA_EXT_HEADERS_B_GT;
662:
663: delete from FA_XLA_EXT_LINES_B_GT_tmp;
664: INSERT INTO FA_XLA_EXT_LINES_B_GT_tmp
665: select * from FA_XLA_EXT_LINES_B_GT;*/