APPS.JG_ZZ_AUDIT_AR_PKG dependencies on JG_ZZ_VAT_TRX_GT

Line 163: FROM jg_zz_vat_trx_gt;

159: -- Record count check
160: CURSOR c_count
161: IS
162: SELECT COUNT(*)
163: FROM jg_zz_vat_trx_gt;
164:
165: l_rec_count NUMBER;
166: lc_curr_code VARCHAR2(50);
167: lc_rep_entity_name jg_zz_vat_trx_details.rep_context_entity_name%TYPE;

Line 228: INSERT INTO jg_zz_vat_trx_gt

224: l_rec_count:=0;
225: t_total_amount := 0;
226: FOR r_jgbevat IN c_jgbevat
227: LOOP
228: INSERT INTO jg_zz_vat_trx_gt
229: (jg_info_v1 -- BE_DOC_SEQ_VALUE
230: ,jg_info_v2 -- CUSTOMER_NAME
231: ,jg_info_v3 -- ADDRESS1
232: ,jg_info_v4 -- CUSTOMER_NUMBER

Line 280: INSERT INTO jg_zz_vat_trx_gt

276:
277: l_rec_count:=0;
278: FOR r_jgczvat IN c_jgczvat
279: LOOP
280: INSERT INTO jg_zz_vat_trx_gt
281: (jg_info_v1 -- CZ_DOC_SEQ_VALUE
282: ,jg_info_v2 -- FUNCTIONAL_CURRENCY_CODE
283: ,jg_info_v3 -- VAT_BOX
284: ,jg_info_v4 -- VAT_BOX_DESC

Line 308: INSERT INTO jg_zz_vat_trx_gt

304:
305: l_rec_count:=0;
306: FOR r_jgzzaudar IN c_jgzzaudar
307: LOOP
308: INSERT INTO jg_zz_vat_trx_gt
309: (jg_info_v1 -- AR_DOC_SEQ_VALUE
310: ,jg_info_v2 -- CUSTOMER_NAME
311: ,jg_info_v3 -- ADDRESS1
312: ,jg_info_v4 -- CUSTOMER_NUMBER

Line 403: INSERT INTO jg_zz_vat_trx_gt (jg_info_v1 -- curr_code

399:
400:
401: if gv_debug then fnd_file.put_line(fnd_file.log,'Calling common pack Inserting Header Info'); end if;
402:
403: INSERT INTO jg_zz_vat_trx_gt (jg_info_v1 -- curr_code
404: ,jg_info_v2 -- entity_name
405: ,jg_info_v3 -- taxpayer_id
406: ,jg_info_v4 -- company_name
407: ,jg_info_v5 -- registration_number