APPS.IGS_PR_GEN_005 dependencies on IGS_PR_SDT_PS_PR_MSR

Line 1670: -- Get the IGS_PR_SDT_PS_PR_MSR value for the student course attempt,

1666: p_prg_ci_sequence_number IN NUMBER,
1667: p_s_prg_measure_type IN VARCHAR2
1668: ) RETURN NUMBER IS
1669: BEGIN -- IGS_PR_get_scpm_value
1670: -- Get the IGS_PR_SDT_PS_PR_MSR value for the student course attempt,
1671: -- progression period and system progression measure type supplied.
1672: DECLARE
1673: v_value NUMBER;
1674: CURSOR c_scpm IS

Line 1676: FROM igs_pr_sdt_ps_pr_msr scpm

1672: DECLARE
1673: v_value NUMBER;
1674: CURSOR c_scpm IS
1675: SELECT scpm.VALUE
1676: FROM igs_pr_sdt_ps_pr_msr scpm
1677: WHERE scpm.person_id = p_person_id
1678: AND scpm.course_cd = p_course_cd
1679: AND scpm.prg_cal_type = p_prg_cal_type
1680: AND scpm.prg_ci_sequence_number = p_prg_ci_sequence_number

Line 1683: FROM igs_pr_sdt_ps_pr_msr scpm2

1679: AND scpm.prg_cal_type = p_prg_cal_type
1680: AND scpm.prg_ci_sequence_number = p_prg_ci_sequence_number
1681: AND scpm.s_prg_measure_type = p_s_prg_measure_type
1682: AND scpm.calculation_dt = (SELECT MAX (scpm2.calculation_dt)
1683: FROM igs_pr_sdt_ps_pr_msr scpm2
1684: WHERE scpm2.person_id = scpm.person_id
1685: AND scpm2.course_cd = scpm.course_cd
1686: AND scpm2.prg_cal_type = scpm.prg_cal_type
1687: AND scpm2.prg_ci_sequence_number = scpm.prg_ci_sequence_number

Line 1698: -- Select IGS_PR_SDT_PS_PR_MSR record

1694: OR p_prg_ci_sequence_number IS NULL
1695: OR p_s_prg_measure_type IS NULL THEN
1696: RETURN NULL;
1697: END IF;
1698: -- Select IGS_PR_SDT_PS_PR_MSR record
1699: OPEN c_scpm;
1700: FETCH c_scpm INTO v_value;
1701: IF c_scpm%NOTFOUND THEN
1702: CLOSE c_scpm;