DBA Data[Home] [Help]

APPS.ZX_MIGRATE_REP_ENTITIES_PKG dependencies on DUAL

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

4797: (select vat_tax_id from ar_vat_tax_all_b )
4798:
4799:
4800: LOOP
4801: select zx_reporting_codes_b_s.nextval into l_seqid from dual;
4802:
4803: INSERT ALL
4804: INTO
4805: ZX_REPORTING_CODES_B

Line 6045: FROM DUAL

6041: fnd_global.conc_program_id , -- Program Id
6042: fnd_global.conc_login_id , -- Program Login ID
6043: 1
6044:
6045: FROM DUAL
6046:
6047: WHERE NOT EXISTS (select 1 from zx_reporting_types_b
6048: where reporting_type_code= p_reporting_type_code
6049: and tax_regime_code IS NULL);

Line 6142: FROM DUAL

6138: fnd_global.prog_appl_id , -- Program Application ID
6139: fnd_global.conc_program_id , -- Program Id
6140: fnd_global.conc_login_id , -- Program Login ID
6141: 1
6142: FROM DUAL
6143: WHERE NOT EXISTS (select 1 from zx_reporting_types_b
6144: where reporting_type_code= p_reporting_type_code
6145: );
6146:

Line 8394: | Description: This is the procedure that calls all API to individually |

8390: END CREATE_REP_CODE_ASSOC_EUVAT;
8391:
8392: /*==========================================================================+
8393: | Procedure: CREATE_REP_ENT_EUVAT |
8394: | Description: This is the procedure that calls all API to individually |
8395: | create Reporting Types, Reporting Usages, Reporting Codes |
8396: | Reporting associations for below Rep Types |
8397: | ZX_INTRA_EU_TRX_TYPE , ZX_LGL_JUSTIFICATN_MSG_TYPE |
8398: | |