APPS.IGS_RU_GEN_003 dependencies on IGS_RU_CALL

Line 315: cp_rule_call_cd IGS_RU_CALL.s_rule_call_cd%TYPE ) IS

311: RETURN IGS_RU_RULE number
312: on error raise exception
313: */
314: CURSOR c_get_rule_dtls (
315: cp_rule_call_cd IGS_RU_CALL.s_rule_call_cd%TYPE ) IS
316: SELECT select_group,
317: s_return_type
318: FROM IGS_RU_CALL,
319: IGS_RU_DESCRIPTION

Line 318: FROM IGS_RU_CALL,

314: CURSOR c_get_rule_dtls (
315: cp_rule_call_cd IGS_RU_CALL.s_rule_call_cd%TYPE ) IS
316: SELECT select_group,
317: s_return_type
318: FROM IGS_RU_CALL,
319: IGS_RU_DESCRIPTION
320: WHERE s_rule_call_cd = p_rule_call_cd
321: AND sequence_number = rud_sequence_number;
322: v_rule VARCHAR2(2000);

Line 323: v_select_group IGS_RU_CALL.select_group%TYPE;

319: IGS_RU_DESCRIPTION
320: WHERE s_rule_call_cd = p_rule_call_cd
321: AND sequence_number = rud_sequence_number;
322: v_rule VARCHAR2(2000);
323: v_select_group IGS_RU_CALL.select_group%TYPE;
324: v_return_type IGS_RU_RET_TYPE.s_return_type%TYPE;
325: v_unprocessed VARCHAR2(2000);
326: v_rule_number IGS_RU_RULE.sequence_number%TYPE;
327: v_lov_number IGS_RU_LOV.sequence_number%TYPE;