APPS.IGS_PR_GEN_006 dependencies on IGS_PR_SDT_PR_RU_CK

Line 417: -- Determine if the IGS_PR_SDT_PR_RU_CK record should be displayed.

413: p_pra_sequence_number IN NUMBER )
414: RETURN VARCHAR2 IS
415: gv_other_detail VARCHAR2(255);
416: BEGIN -- IGS_PR_get_sprc_dsp
417: -- Determine if the IGS_PR_SDT_PR_RU_CK record should be displayed.
418: -- 1. If there is an IGS_PR_STDNT_PR_OU record linked to it
419: -- 2. If it is the most recent of passed or failed record
420: DECLARE
421: v_dummy VARCHAR2(1);

Line 435: FROM IGS_PR_SDT_PR_RU_CK sprc

431: pra_sequence_number = p_pra_sequence_number AND
432: decision_status IN ('APPROVED', 'PENDING');
433: CURSOR c_sprc IS
434: SELECT 'X'
435: FROM IGS_PR_SDT_PR_RU_CK sprc
436: WHERE sprc.person_id = p_person_id AND
437: sprc.course_cd = p_course_cd AND
438: sprc.prg_cal_type = p_prg_cal_type AND
439: sprc.prg_ci_sequence_number = p_prg_ci_sequence_number AND

Line 445: FROM IGS_PR_SDT_PR_RU_CK sprc2

441: sprc.progression_rule_cat = p_progression_rule_cat AND
442: sprc.pra_sequence_number = p_pra_sequence_number AND
443: sprc.rule_check_dt
444: = ( SELECT MAX(sprc2.rule_check_dt)
445: FROM IGS_PR_SDT_PR_RU_CK sprc2
446: WHERE sprc2.person_id = sprc.person_id AND
447: sprc2.course_cd = sprc.course_cd AND
448: sprc2.prg_cal_type = sprc.prg_cal_type AND
449: sprc2.prg_ci_sequence_number = sprc.prg_ci_sequence_number AND