DBA Data[Home] [Help]

APPS.XLA_REVERSE_EVENTS_PVT_PKG dependencies on XLA_AE_HEADERS_GT

Line 676: INSERT INTO XLA_AE_HEADERS_GT

672: -- Data is inserted into Headers_GT to maintain the relationship between
673: -- new_header_id and original_header_id from which reversal_accounting is created
674: -- PARENT_HEADER_ID contains the ORIGINAL_HEADER_ID
675: -- EVENT_NUMBER contains the ORIGINAL_EVENT_ID corresponding to ORIGINAL_HEADER_ID
676: INSERT INTO XLA_AE_HEADERS_GT
677: ( AE_HEADER_ID
678: ,LEDGER_ID
679: ,ENTITY_ID
680: ,EVENT_ID

Line 811: FROM XLA_AE_HEADERS_GT

807: ,sysdate
808: ,g_last_updated_by
809: ,g_last_update_login
810: ,-9999
811: FROM XLA_AE_HEADERS_GT
812: ;
813:
814: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
815: trace

Line 845: xla_ae_headers_gt xah

841: ,xah_acs.ac4
842: ,xah_acs.ac5
843: ,1
844: FROM xla_ae_header_acs xah_acs ,
845: xla_ae_headers_gt xah
846: WHERE xah_acs.ae_header_id = xah.parent_header_id;
847:
848: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
849: trace

Line 989: xla_ae_headers_gt xah ,

985: ) CONTROL_BALANCE_FLAG
986: ,DECODE(NVL(xal.analytical_balance_flag ,'N'),'N',NULL,'P')
987: , -9999
988: FROM xla_ae_lines xal ,
989: xla_ae_headers_gt xah ,
990: xla_ledger_options xlo ,
991: gl_ledgers gl
992: WHERE xal.application_id = g_application_id
993: AND xal.ae_header_id = xah.parent_header_id

Line 1033: , xla_ae_headers_gt xah

1029: ,xal_acs.ac4
1030: ,xal_acs.ac5
1031: ,1
1032: FROM xla_ae_line_acs xal_acs
1033: , xla_ae_headers_gt xah
1034: WHERE xal_acs.ae_header_id = xah.parent_header_id ;
1035:
1036: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1037: trace

Line 1082: FROM xla_ae_headers_gt xah

1078: ,xal.unrounded_entered_cr
1079: ,xal.unrounded_accounted_dr
1080: ,xal.unrounded_accounted_cr
1081: ,-9999
1082: FROM xla_ae_headers_gt xah
1083: ,xla_ae_lines xal
1084: WHERE 1 = 1
1085: AND xal.application_id = g_application_id
1086: AND xal.ae_header_id = xah.ae_header_id;