APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_RU_DESCRIPTION

Line 8592: l_c_rule_desc igs_ru_description.rule_description%TYPE;

8588: ***********************************************************************************************/
8589:
8590: l_n_uoo_id NUMBER;
8591: l_n_select_group NUMBER;
8592: l_c_rule_desc igs_ru_description.rule_description%TYPE;
8593: l_n_rule_number NUMBER;
8594: l_success BOOLEAN;
8595: l_c_rule_unprocessed VARCHAR2(4500);
8596: l_n_lov_number NUMBER;

Line 8740: FROM igs_ru_call rc,igs_ru_description rd

8736: PROCEDURE Business_validation(p_usec_rule_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rule_rec_type) AS
8737:
8738: CURSOR cur_rule_check IS
8739: SELECT rc.select_group,rd.rule_description
8740: FROM igs_ru_call rc,igs_ru_description rd
8741: WHERE rc.s_rule_type_cd = 'USEC'
8742: AND rc.s_rule_call_cd = p_usec_rule_rec.s_rule_call_cd
8743: AND rc.rud_sequence_number = rd.sequence_number;
8744: