APPS.HZ_IMP_LOAD_RELATIONSHIPS_PKG dependencies on HZ_IMP_RELSHIPS_SG

Line 428: from hz_imp_relships_sg rel_sg, hz_imp_relships_int rel_int

424: 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',
425: 'Y','Y',
426: dup_val_exp_val,
427: other_exp_val
428: from hz_imp_relships_sg rel_sg, hz_imp_relships_int rel_int
429: where rel_sg.action_flag = 'I'
430: and rel_int.rowid = rel_sg.int_row_id
431: and rel_sg.batch_id = P_DML_RECORD.BATCH_ID
432: and rel_sg.sub_orig_system = P_DML_RECORD.OS

Line 1077: from hz_imp_relships_sg irs,

1073: nvl2(nullif(nullif(ri.insert_update_flag, :p_gmiss_char), irs.action_flag),
1074: null, ''Y'') action_mismatch_error,
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

Line 1378: FROM HZ_IMP_RELSHIPS_INT ri, HZ_IMP_RELSHIPS_SG rs,

1374: ri.ATTRIBUTE20,
1375: decode(nvl(ri.insert_update_flag, rs.action_flag), rs.action_flag, ''Y'', null) action_mismatch_error,
1376: 0 flex_val_errors,
1377: ''T'' dss_security_error
1378: FROM HZ_IMP_RELSHIPS_INT ri, HZ_IMP_RELSHIPS_SG rs,
1379: HZ_RELATIONSHIPS r
1380: WHERE
1381: ri.rowid = rs.int_row_id
1382: AND rs.relationship_id = r.relationship_id