APPS.GCS_AD_ENGINE dependencies on GCS_ELIM_RULES_VL
Line 94: FROM GCS_ELIM_RULES_VL r
90: --Find the correct elimination rule id(s)
91: --5.17.04: Add condition: enabled_flag='Y'
92: cursor ruleCursor (i number) is
93: SELECT r.rule_id, r.rule_name 94: FROM GCS_ELIM_RULES_VL r 95: WHERE r.transaction_type_code = ruleAtts(i).xnsTypeCode
96: AND r.from_treatment_id = ruleAtts(i).oldTreatment
97: AND r.to_treatment_id = ruleAtts(i).newTreatment
98: AND r.enabled_flag ='Y';