APPS.HZ_IMP_LOAD_ADDRESSES_PKG dependencies on DUAL

Line 1086: from dual

1082: and hz_ps.party_site_id = l_error_site_id(i)
1083: union -- nullify if no next available address
1084: select null,null,null,null,null,
1085: null,null,null,null,null
1086: from dual
1087: where l_error_site_id(i) is null
1088: ),
1089: object_version_number = object_version_number + 1,
1090: last_update_date = P_DML_RECORD.SYSDATE,

Line 2296: from dual

2292: nullif(nvl(l_attr17(j), l_attr17(j)), P_DML_RECORD.GMISS_CHAR),
2293: nullif(nvl(l_attr18(j), l_attr18(j)), P_DML_RECORD.GMISS_CHAR),
2294: nullif(nvl(l_attr19(j), l_attr19(j)), P_DML_RECORD.GMISS_CHAR),
2295: nullif(nvl(l_attr20(j), l_attr20(j)), P_DML_RECORD.GMISS_CHAR)
2296: from dual
2297: where l_action_error_flag(j) is not null
2298: and l_error_flag(j) is null
2299: and l_address_err(j) is not null
2300: and l_country_err(j) is not null

Line 2523: from dual

2519: P_DML_RECORD.REQUEST_ID,
2520: P_DML_RECORD.PROGRAM_APPLICATION_ID,
2521: P_DML_RECORD.PROGRAM_ID,
2522: P_DML_RECORD.SYSDATE
2523: from dual
2524: where ( l_maintain_loc_hist = 'Y' and (l_init_upd_count(j) = 1) )
2525: or l_move_count(j) = 1
2526: );
2527:

Line 2661: from dual

2657: P_DML_RECORD.REQUEST_ID,
2658: P_DML_RECORD.PROGRAM_APPLICATION_ID,
2659: P_DML_RECORD.PROGRAM_ID,
2660: P_DML_RECORD.SYSDATE
2661: from dual
2662: where l_accept_std_flag(j) is not null
2663: and (l_move_count(j) = 1 -- record moved
2664: or ( l_corr_upd_count(j) = 1 -- record corrected/updated
2665: and ( l_temp_upd_count(j) = 0 -- std loc profile does not exist

Line 2740: from dual

2736: P_DML_RECORD.REQUEST_ID,
2737: P_DML_RECORD.PROGRAM_APPLICATION_ID,
2738: P_DML_RECORD.PROGRAM_ID,
2739: P_DML_RECORD.SYSDATE
2740: from dual
2741: where l_accept_std_flag(j) is not null
2742: and (l_move_count(j) = 1 -- record moved
2743: or ( l_corr_upd_count(j) = 1 -- record corrected/updated
2744: and ( l_temp_upd_count(j) = 0 -- std loc profile does not exist

Line 2826: from dual

2822: nvl(l_created_by_module(j), 'HZ_IMPORT'),
2823: P_DML_RECORD.APPLICATION_ID,
2824: decode(l_accept_std_flag(j), 'Y', l_valid_status_code(j), null),
2825: decode(l_accept_std_flag(j), 'Y', l_date_validated(j), null)
2826: from dual
2827: where l_move_count(j) = 1);
2828:
2829: /* end-date collided entries if */
2830: /* 1) record moved and collision happens

Line 2904: from dual

2900: P_DML_RECORD.REQUEST_ID,
2901: P_DML_RECORD.PROGRAM_APPLICATION_ID,
2902: P_DML_RECORD.PROGRAM_ID,
2903: P_DML_RECORD.SYSDATE
2904: from dual
2905: where ( l_move_count(j) = 1 or
2906: (l_corr_upd_count(j) = 1 and
2907: l_site_orig_system_reference(j) <> l_old_site_osr(j)))
2908: );

Line 3162: from dual

3158: nvl2(l_owner_table_id(j),'Y',null) MISSING_PARENT_FLAG,
3159: decode(l_dss_security_errors(j), FND_API.G_TRUE,'Y',null) E8_FLAG, -- e8
3160: l_third_party_update_error(j) E9_FLAG, --e9
3161: l_createdby_errors(j) E11_FLAG
3162: from dual
3163: where l_num_row_processed(j) = 0
3164: ) v
3165: WHERE v.ACTION_MISMATCH_FLAG is null
3166: OR v.E1_FLAG is null