APPS.JE_NO_VAT_RECON_PKG dependencies on JGZZ_AR_TAX_GLOBAL_TMP

Line 95: 'jgzz_ar_tax_global_tmp jgzz,'||

91: ', jgzz.jg_info_d1'||
92: ', ca.acctd_amount'||
93: ' from ra_customer_trx_lines_all ra,'||
94: 'ra_cust_trx_line_gl_dist_all ca,'||
95: 'jgzz_ar_tax_global_tmp jgzz,'||
96: 'gl_code_combinations cc '||
97: 'where ra.customer_trx_id=jgzz.jg_info_n1 '||
98: 'and ra.line_number=jgzz.jg_info_n9 '||
99: 'and ra.customer_trx_line_id=ca.customer_trx_line_id '||

Line 147: insert into jgzz_ar_tax_global_tmp (

143: h_jg_info_n7 := 0;
144: h_jg_info_n13 := 0;
145: end if;
146:
147: insert into jgzz_ar_tax_global_tmp (
148: JG_INFO_V1,
149: JG_INFO_V2,
150: JG_INFO_V3,
151: JG_INFO_V4,

Line 246: delete from jgzz_ar_tax_global_tmp

242:
243: END LOOP;
244: CLOSE upd_ar1;
245:
246: delete from jgzz_ar_tax_global_tmp
247: where jg_info_v2 = 'AR'
248: and jg_info_v7 <> 'OFFSET'
249: and (jg_info_d15 is null
250: or jg_info_d15 <> to_date('2049/12/31','YYYY/MM/DD'));