4770: (select vat_tax_id from ar_vat_tax_all_b )
4771:
4772:
4773: LOOP
4774: select zx_reporting_codes_b_s.nextval into l_seqid from dual;
4775:
4776: INSERT ALL
4777: INTO
4778: ZX_REPORTING_CODES_B
6012: fnd_global.conc_program_id , -- Program Id
6013: fnd_global.conc_login_id , -- Program Login ID
6014: 1
6015:
6016: FROM DUAL
6017:
6018: WHERE NOT EXISTS (select 1 from zx_reporting_types_b
6019: where reporting_type_code= p_reporting_type_code
6020: and tax_regime_code IS NULL);
6109: fnd_global.prog_appl_id , -- Program Application ID
6110: fnd_global.conc_program_id , -- Program Id
6111: fnd_global.conc_login_id , -- Program Login ID
6112: 1
6113: FROM DUAL
6114: WHERE NOT EXISTS (select 1 from zx_reporting_types_b
6115: where reporting_type_code= p_reporting_type_code
6116: );
6117: