APPS.HZ_IMP_LOAD_CODE_ASSIGNMENTS dependencies on HZ_IMP_CLASSIFICS_SG

Line 345: from hz_imp_classifics_sg clsf_sg, hz_imp_classifics_int clsf_int

341: 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',
342: dup_val_exp_val,
343: other_exp_val,
344: 'Y','Y'
345: from hz_imp_classifics_sg clsf_sg, hz_imp_classifics_int clsf_int
346: where clsf_sg.action_flag = 'I'
347: and clsf_int.rowid = clsf_sg.int_row_id
348: and clsf_int.batch_id = P_DML_RECORD.BATCH_ID
349: and clsf_int.party_orig_system = P_DML_RECORD.OS

Line 508: from hz_imp_classifics_sg cas,

504: decode(tc1.a, 0, ''Y'') identical_classcode_error,
505: decode(tc2.a, 0, ''Y'') multi_assign_error,
506: decode(tc3.a, 0, ''Y'') leaf_node_error,
507: decode(cai.created_by_module, :p_gmiss_char, ''Y'', null, ''Y'', nvl2(createdby_l.lookup_code,''Y'',null)) createdby_error
508: from hz_imp_classifics_sg cas,
509: hz_imp_classifics_int cai,
510: fnd_lookup_values class_code_lookups,
511: hz_class_categories class_cat,
512: tc tc1, tc tc2, tc tc3,

Line 856: hz_imp_classifics_sg cls_sg,

852: rank() over (partition by
853: cls_sg.party_id, cls_sg.class_category order by
854: cls_sg.code_assignment_id) r
855: from HZ_IMP_TMP_ERRORS err_table,
856: hz_imp_classifics_sg cls_sg,
857: hz_parties hp
858: where err_table.request_id = :request_id
859: and err_table.interface_table_name = ''HZ_IMP_CLASSIFICS_INT''
860: and cls_sg.batch_id = :batch_id

Line 881: /* Bug 409189: when checking class_category in hz_imp_classifics_sg,

877:
878: close primary_flag_err_cursor;
879:
880: -- nullify denorm column in hz_parties
881: /* Bug 409189: when checking class_category in hz_imp_classifics_sg,
882: check for 'SIC' instead of the individual SIC code type as this is how
883: matching populates the column */
884: forall i in 1..l_error_party_id.count
885: update hz_parties hz_pty

Line 940: from hz_imp_classifics_sg cls_sg,

936: cls_sg.code_assignment_id,
937: cls_sg.class_category,
938: cls_sg.class_code,
939: cls_int.class_category
940: from hz_imp_classifics_sg cls_sg,
941: hz_imp_parties_sg p_sg,
942: hz_imp_classifics_int cls_int,
943: hz_code_assignments hca
944: where cls_sg.batch_id = :batch_id

Line 976: from hz_imp_classifics_sg

972: denormalization. These are used for calling HZ_MIXNM_CONC_DYNAMIC_PKG to
973: derive SST. */
974: OPEN pid_cursor FOR
975: 'select max(party_id), min(party_id)
976: from hz_imp_classifics_sg
977: where batch_id = :batch_id
978: and batch_mode_flag = :batch_mode_flag
979: and party_orig_system = :orig_system
980: and party_orig_system_reference between :from_osr and :to_osr

Line 1107: HZ_IMP_CLASSIFICS_SG cas,

1103:
1104: decode(tc1.a, 0, ''Y'') identical_classcode_error,
1105: decode(tc2.a, 0, ''Y'') multi_assign_error
1106: FROM HZ_IMP_CLASSIFICS_INT cai,
1107: HZ_IMP_CLASSIFICS_SG cas,
1108: (select 0 a from dual union all select 1 a from dual) tc1,
1109: (select 0 a from dual union all select 1 a from dual) tc2
1110: WHERE
1111: cas.batch_id = :P_BATCH_ID