APPS.JG_ZZ_SUMMARY_AP_PKG dependencies on JG_ZZ_VAT_TRX_GT

Line 390: FROM JG_ZZ_VAT_TRX_GT tmp,

386: tmp.rowid,
387: jg_info_v14 tax_code,
388: jg_info_n5 trx_id,
389: jg_info_v15 reporting_code
390: FROM JG_ZZ_VAT_TRX_GT tmp,
391: gl_periods glp,
392: jg_zz_vat_rep_status JZVRS
393: WHERE jg_info_v9 = 'M'
394: AND JZVRS.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID

Line 722: INSERT INTO JG_ZZ_VAT_TRX_GT

718: THEN
719: l_ledger_id := -1;
720: END IF;
721:
722: INSERT INTO JG_ZZ_VAT_TRX_GT
723: (jg_info_v1 -- curr_code
724: ,jg_info_v2 -- entity_name
725: ,jg_info_v3 -- taxpayer_id
726: ,jg_info_v4 -- company_name

Line 762: if g_debug = true then fnd_file.put_line(fnd_file.log,'Inserted Company Details in JG_ZZ_VAT_TRX_GT table'); end if;

758: ,l_tax_registration_num
759: ,l_period_start_date
760: ,l_period_end_date
761: ,l_reporting_status);
762: if g_debug = true then fnd_file.put_line(fnd_file.log,'Inserted Company Details in JG_ZZ_VAT_TRX_GT table'); end if;
763:
764: IF P_CALLING_REPORT IS NOT NULL THEN --A1
765:
766: /* commented during UT TEST

Line 847: INSERT INTO JG_ZZ_VAT_TRX_GT

843: --Populated the data for VAT AP Detail Report and VAT-File Not Related 835 -Israel
844: FOR israel_inv_lines IN israel_details
845: LOOP
846:
847: INSERT INTO JG_ZZ_VAT_TRX_GT
848: (jg_info_v1 , --vendor_name
849: -- jg_info_n1 , --vendor_number
850: jg_info_v6 , --Vendor Number
851: jg_info_v2 , --SITE_NAME

Line 918: INSERT INTO JG_ZZ_VAT_TRX_GT

914: ,pv_offset_tax_code => c_data_rec1.OFFSET_TAX_RATE_CODE
915: ,pd_end_date => c_data_rec1.PERIOD_END_DATE);
916:
917:
918: INSERT INTO JG_ZZ_VAT_TRX_GT
919: (jg_info_n1 -- seq_number
920: ,jg_info_v1 -- inv_number
921: ,jg_info_v2 -- customer_name
922: ,jg_info_d1 -- tax_date

Line 1007: INSERT INTO JG_ZZ_VAT_TRX_GT

1003: ,pn_taxable_amount => c_data_rec.taxable_amount
1004: ,pv_offset_tax_code => c_data_rec.OFFSET_TAX_RATE_CODE
1005: ,pd_end_date => c_data_rec.PERIOD_END_DATE);
1006:
1007: INSERT INTO JG_ZZ_VAT_TRX_GT
1008: (jg_info_n1 -- seq_number
1009: ,jg_info_v1 -- inv_number
1010: ,jg_info_v2 -- customer_name
1011: ,jg_info_d1 -- tax_date

Line 1113: FROM JG_ZZ_VAT_TRX_GT T1

1109: END IF;
1110:
1111: SELECT distinct JG_INFO_V40
1112: INTO v_is_seq_updated
1113: FROM JG_ZZ_VAT_TRX_GT T1
1114: WHERE T1.jg_info_n5 = c_data.trx_id
1115: AND T1.jg_info_v7 = c_data.vat_code
1116: AND T1.jg_info_v15 = c_data.reporting_code;
1117:

Line 1122: UPDATE JG_ZZ_VAT_TRX_GT SET jg_info_n1 = v_count ,

1118: IF NVL(v_is_seq_updated,'N') <> 'Y' THEN
1119:
1120: v_count := v_count+1;
1121:
1122: UPDATE JG_ZZ_VAT_TRX_GT SET jg_info_n1 = v_count ,
1123: jg_info_v40 = 'Y'
1124: WHERE jg_info_n5 = c_data.trx_id
1125: AND jg_info_v7 = c_data.vat_code
1126: AND jg_info_v15 = c_data.reporting_code;

Line 1240: INSERT INTO JG_ZZ_VAT_TRX_GT

1236: FOR c_data_rec2 IN c_complete
1237: LOOP
1238:
1239:
1240: INSERT INTO JG_ZZ_VAT_TRX_GT
1241: (jg_info_n1 -- seq_number
1242: ,jg_info_v1 -- inv_number
1243: ,jg_info_v2 -- customer_name
1244: ,jg_info_d1 -- tax_date