APPS.IGS_EN_GEN_015 dependencies on IGS_PS_STAGE

Line 1401: FROM igs_ps_stage

1397: ) RETURN BOOLEAN AS
1398: --
1399: CURSOR cur_seq_num IS
1400: SELECT sequence_number
1401: FROM igs_ps_stage
1402: WHERE course_cd = p_course_cd AND
1403: version_number = p_version_number AND
1404: course_stage_type = p_preference_code
1405: ORDER BY sequence_number;

Line 1425: l_cur_seq_num igs_ps_stage.sequence_number%TYPE;

1421: key_5 = cp_key_5) AND
1422: (cp_key_6 IS NULL OR
1423: key_6 = cp_key_6);
1424: --
1425: l_cur_seq_num igs_ps_stage.sequence_number%TYPE;
1426: lv_message_name VARCHAR2(30);
1427: l_crs_stg_result_rec igs_pr_s_scratch_pad_v.text_1%TYPE;
1428: lv_log_dt DATE;
1429: --