DBA Data[Home] [Help]

APPS.ZX_MIGRATE_REP_ENTITIES_PKG dependencies on DUAL

Line 4774: select zx_reporting_codes_b_s.nextval into l_seqid from dual;

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

Line 6016: FROM DUAL

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);

Line 6113: FROM DUAL

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: