APPS.IGS_AD_IMP_023 dependencies on IGS_AD_DSCP_ATTR

Line 28: FROM igs_ad_dscp_attr

24:
25: -- Define cursor to get the Detail Level Discrepancy Rule.
26: CURSOR get_discrepancy_rule_cur IS
27: SELECT discrepancy_rule_cd
28: FROM igs_ad_dscp_attr
29: WHERE UPPER(attribute_name) = UPPER(p_attribute_name)
30: AND src_cat_id = (SELECT src_cat_id
31: FROM igs_ad_source_cat
32: WHERE source_type_id = p_source_type_id

Line 79: FROM igs_ad_dscp_attr

75:
76: -- Define cursor to get the Detail Level Discrepancy Rule.
77: CURSOR get_discrepancy_rule_cur IS
78: SELECT discrepancy_rule_cd
79: FROM igs_ad_dscp_attr
80: WHERE UPPER(attribute_name) = UPPER(p_attribute_name)
81: AND src_cat_id = (SELECT src_cat_id
82: FROM igs_ad_source_cat
83: WHERE source_type_id = p_source_type_id

Line 130: FROM igs_ad_dscp_attr

126:
127: -- Define cursor to get the Detail Level Discrepancy Rule.
128: CURSOR get_discrepancy_rule_cur IS
129: SELECT discrepancy_rule_cd
130: FROM igs_ad_dscp_attr
131: WHERE UPPER(attribute_name) = UPPER(p_attribute_name)
132: AND src_cat_id = (SELECT src_cat_id
133: FROM igs_ad_source_cat
134: WHERE source_type_id = p_source_type_id

Line 260: FROM igs_ad_dscp_attr

256:
257: -- Get the ATTRIBUTE_NAME for which discrepancy rule is marked for Review.
258: CURSOR detail_discrepancy_cur(cp_src_cat_id igs_ad_source_cat.src_cat_id%TYPE) IS
259: SELECT *
260: FROM igs_ad_dscp_attr
261: WHERE src_cat_id = cp_src_cat_id
262: AND NVL(discrepancy_rule_cd,'I') = 'R';
263:
264: detail_discrepancy_rec detail_discrepancy_cur%ROWTYPE;

Line 400: FROM igs_ad_dscp_attr

396:
397: -- Check if any column discrepancy rule is marked for Review : 'R'.
398: CURSOR check_dtl_for_rev_cur IS
399: SELECT count(ROWID)
400: FROM igs_ad_dscp_attr
401: WHERE src_cat_id = (SELECT src_cat_id
402: FROM igs_ad_source_cat
403: WHERE category_name = p_category
404: AND source_type_id = p_Source_type_id)

Line 410: FROM igs_ad_dscp_attr

406:
407: -- Check if any column discrepancy rule is marked for Import : 'I'.
408: CURSOR check_dtl_for_import_cur IS
409: SELECT count(ROWID)
410: FROM igs_ad_dscp_attr
411: WHERE src_cat_id = (SELECT src_cat_id
412: FROM igs_ad_source_cat
413: WHERE category_name = p_category
414: AND source_type_id = p_Source_type_id)