APPS.HZ_IMP_LOAD_WRAPPER dependencies on DUAL

Line 4064: SELECT hz_imp_errors_s.NEXTVAL INTO l_start_error_id FROM dual;

4060: fnd_stats.gather_table_stats('AR', 'HZ_ORIG_SYS_REFERENCES', percent=>5, degree=>4);
4061: END IF;
4062:
4063: -- get the start error_id sequence number
4064: SELECT hz_imp_errors_s.NEXTVAL INTO l_start_error_id FROM dual;
4065:
4066: /* Dup check of relationships and address uses within interface,
4067: V+DML of other entities, PP-Wait */
4068: ident_dup_within_int(P_BATCH_ID, P_ORIG_SYSTEM, P_BATCH_MODE_FLAG, P_REQUEST_ID,

Line 4072: SELECT hz_imp_errors_s.CURRVAL INTO l_current_error_id FROM dual;

4068: ident_dup_within_int(P_BATCH_ID, P_ORIG_SYSTEM, P_BATCH_MODE_FLAG, P_REQUEST_ID,
4069: D_SYSDATE, l_user_id, l_last_update_login,
4070: P_PROGRAM_APPLICATION_ID, P_PROGRAM_ID);
4071:
4072: SELECT hz_imp_errors_s.CURRVAL INTO l_current_error_id FROM dual;
4073:
4074: -- if error is greater than error limit
4075: IF l_current_error_id - l_start_error_id >=
4076: NVL(P_ERROR_LIMIT, NVL(FND_PROFILE.value('HZ_IMP_ERROR_LIMIT'), 10000)) THEN

Line 4667: FROM dual

4663: ) RETURN VARCHAR2 IS
4664:
4665: CURSOR c_what_if_sg_data(p_batch_id number, p_batch_mode_flag varchar2) IS
4666: SELECT 'Y'
4667: FROM dual
4668: WHERE EXISTS (
4669: SELECT 'Y'
4670: FROM HZ_IMP_PARTIES_SG
4671: WHERE batch_id = p_batch_id

Line 4738: FROM dual

4734:
4735: CURSOR c_what_if_sg_data2(p_batch_id number, p_batch_mode_flag varchar2) IS
4736:
4737: SELECT 'Y'
4738: FROM dual
4739: WHERE EXISTS (
4740: SELECT 'Y'
4741: FROM HZ_IMP_ADDRESSES_SG
4742: WHERE batch_id = p_batch_id