APPS.IGS_RU_DESCRIPTION_PKG dependencies on IGS_RU_ITEM

Line 136: FROM IGS_RU_ITEM

132: END LOOP;
133: -- else find the calling IGS_RU_RULE and try again
134: FOR rui IN (
135: SELECT rul_sequence_number
136: FROM IGS_RU_ITEM
137: WHERE rule_number = p_rule_number )
138: LOOP
139: do_rule_text(rui.rul_sequence_number);
140: END LOOP;

Line 152: FROM IGS_RU_ITEM

148: -- find all rules which use this turing function
149: FOR rui IN (
150: SELECT UNIQUE
151: rul_sequence_number
152: FROM IGS_RU_ITEM
153: WHERE turin_function = New_References.S_TURIN_FUNCTION )
154: LOOP
155: -- update the IGS_RU_RULE text of this named IGS_RU_RULE
156: do_rule_text(rui.rul_sequence_number);

Line 164: IGS_RU_ITEM rui

160: FOR nr IN (
161: SELECT UNIQUE
162: rui.rul_sequence_number
163: FROM IGS_RU_NAMED_RULE nr,
164: IGS_RU_ITEM rui
165: WHERE nr.rud_sequence_number = New_References.sequence_number
166: AND rui.named_rule = nr.rul_sequence_number )
167: LOOP
168: -- update the IGS_RU_RULE text of this named IGS_RU_RULE