APPS.IGS_PR_GEN_006 dependencies on IGS_PR_RU_CAT

Line 1017: v_s_rule_call_cd IGS_PR_RU_CAT.s_rule_call_cd%TYPE;

1013: v_pra_spo_course_cd IGS_PR_RU_APPL.spo_course_cd%TYPE;
1014: v_pra_spo_sequence_number IGS_PR_RU_APPL.spo_sequence_number%TYPE;
1015: v_pra_message IGS_PR_RU_APPL.message%TYPE;
1016: v_pra_reference_cd IGS_PR_RU_APPL.reference_cd%TYPE;
1017: v_s_rule_call_cd IGS_PR_RU_CAT.s_rule_call_cd%TYPE;
1018: v_new_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE;
1019: v_new_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE;
1020: v_rul_sequence_number IGS_PR_RU_APPL.rul_sequence_number%TYPE;
1021: v_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE;

Line 1049: FROM IGS_PR_RU_CAT prgc

1045: pra.sequence_number = p_sequence_number AND
1046: pra.logical_delete_dt IS NULL;
1047: CURSOR c_prgc IS
1048: SELECT prgc.s_rule_call_cd
1049: FROM IGS_PR_RU_CAT prgc
1050: WHERE prgc.progression_rule_cat = p_progression_rule_cat;
1051: CURSOR c_pra_sequence_number IS
1052: SELECT IGS_PR_PRA_SEQUENCE_NO_S.NEXTVAL
1053: FROM dual;