[Home] [Help]
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;
1054: CURSOR c_pro_sequence_number IS
1055: --gjha Changed the sequence fromPRA to PRO.
1056: