APPS.HZ_IMP_LOAD_RELATIONSHIPS_PKG dependencies on DUAL

Line 344: from dual

340: decode(l_dss_security_errors(j), FND_API.G_TRUE,'Y',null), --HZ_DSS_SECURITY_FAIL,USER_NAME,FND_GLOBAL.user_name,OPER_NAME,UPDATE,OBJECT_NAME,HZ_RELATIONSHIPS
341: 'Y',
342: nvl2(l_action_mismatch_errors(j), 'Y', null), --HZ_IMP_ACTION_MISMATCH
343: l_exception_exists(j)
344: from dual
345: where l_num_row_processed(j) = 0
346: );
347:
348: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1079: (select 0 a from dual union all select 1 a from dual) tc,

1075: decode(tc.a, 0, ''Y'') dup_rel_error,
1076: tc.a dup_rel_count
1077: from hz_imp_relships_sg irs,
1078: hz_imp_relships_int ri,
1079: (select 0 a from dual union all select 1 a from dual) tc,
1080: hz_parties sp,
1081: hz_parties op
1082: where irs.batch_mode_flag = :p_batch_mode_flag
1083: and irs.action_flag = ''I''