[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT NVL(cfg.ledger_id,glp.ledger_id)
FROM jg_zz_vat_rep_entities cfg,
jg_zz_vat_rep_entities cfgd,
gl_ledger_le_v glp
WHERE cfg.vat_reporting_entity_id = 10001
AND ( ( cfg.entity_type_code = 'ACCOUNTING'
AND cfg.mapping_vat_rep_entity_id = cfgd.vat_reporting_entity_id
AND glp.legal_entity_id = cfgd.legal_entity_id)
OR
( cfg.entity_type_code = 'LEGAL'
AND cfg.vat_reporting_entity_id = cfgd.vat_reporting_entity_id
AND glp.legal_entity_id = cfg.legal_entity_id)
)
AND glp.ledger_category_code = 'PRIMARY';
FND_FILE.PUT_LINE(FND_FILE.LOG,'insert JG_ZZ_VAT_TRX_GT-5');
INSERT INTO JG_ZZ_VAT_TRX_GT(
jg_info_v1
, jg_info_v2
, jg_info_v3
, jg_info_v4
, jg_info_v5
, jg_info_v6
, jg_info_v7
, jg_info_v8
, jg_info_v9
, jg_info_v10
, jg_info_v11
, jg_info_v12
, jg_info_v13
, jg_info_v14
, jg_info_v15
, jg_info_n1
, jg_info_n2
, jg_info_v17
, jg_info_d1
, jg_info_d2
, jg_info_v16
, jg_info_v18
)
VALUES
(
l_func_curr_code -- curr_code
, l_company_name -- l_rep_legal_entity -- entity_name
, l_company_name -- company_name
, l_registration_number -- registration_number
, l_country -- country
, l_address1 -- address1
, l_address2 -- address2
, l_address3 -- address3
, l_address4 -- address4
, l_city -- city
, l_postal_code -- postal_code
, l_contact -- contact
, l_phone_number -- phone_number
, l_reporting_mode -- reporting mode
, l_trn -- trn
, l_rep_legal_entity_id -- legalentity_id
, l_period_year -- period_year
, l_registration_number -- l_taxpayer_id -- taxpayer_id
, l_period_start_date -- period_start_date
, l_period_end_date -- period_end_date
, 'H' -- Header record indicator
, l_enable_report_seq_flag -- Enable Report Seq Flag
);