eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_PRC_LOAD dependencies on IGS_EN_SU_ATTEMPT

Line 103: FROM IGS_EN_SU_ATTEMPT sua

99: SELECT sua.discontinued_dt,
100: sua.administrative_unit_status,
101: sua.unit_attempt_status,
102: sua.no_assessment_ind
103: FROM IGS_EN_SU_ATTEMPT sua
104: WHERE sua.person_id = p_person_id AND
105: sua.course_cd = p_course_cd AND
106: sua.uoo_id = p_uoo_id;
107: v_sua_rec c_sua%ROWTYPE;

Line 109: CURSOR c_cir (cp_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE,

105: sua.course_cd = p_course_cd AND
106: sua.uoo_id = p_uoo_id;
107: v_sua_rec c_sua%ROWTYPE;
108:
109: CURSOR c_cir (cp_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE,
110: cp_administrative_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE,
111: cp_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE,
112: cp_no_assessment_ind IGS_EN_SU_ATTEMPT.no_assessment_ind%TYPE) IS
113: SELECT lci.cal_type,

Line 110: cp_administrative_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE,

106: sua.uoo_id = p_uoo_id;
107: v_sua_rec c_sua%ROWTYPE;
108:
109: CURSOR c_cir (cp_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE,
110: cp_administrative_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE,
111: cp_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE,
112: cp_no_assessment_ind IGS_EN_SU_ATTEMPT.no_assessment_ind%TYPE) IS
113: SELECT lci.cal_type,
114: lci.sequence_number

Line 111: cp_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE,

107: v_sua_rec c_sua%ROWTYPE;
108:
109: CURSOR c_cir (cp_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE,
110: cp_administrative_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE,
111: cp_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE,
112: cp_no_assessment_ind IGS_EN_SU_ATTEMPT.no_assessment_ind%TYPE) IS
113: SELECT lci.cal_type,
114: lci.sequence_number
115: FROM IGS_CA_INST_REL acir,

Line 112: cp_no_assessment_ind IGS_EN_SU_ATTEMPT.no_assessment_ind%TYPE) IS

108:
109: CURSOR c_cir (cp_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE,
110: cp_administrative_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE,
111: cp_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE,
112: cp_no_assessment_ind IGS_EN_SU_ATTEMPT.no_assessment_ind%TYPE) IS
113: SELECT lci.cal_type,
114: lci.sequence_number
115: FROM IGS_CA_INST_REL acir,
116: IGS_CA_INST aci,

Line 240: p_key_course_cd IN igs_en_su_attempt.course_cd%TYPE,

236: p_load_cal_type IN VARCHAR2 ,
237: p_load_sequence_number IN NUMBER ,
238: p_truncate_ind IN VARCHAR2 ,
239: p_include_research_ind IN VARCHAR2 ,
240: p_key_course_cd IN igs_en_su_attempt.course_cd%TYPE,
241: p_key_version_number IN igs_en_su_attempt.version_number%TYPE,
242: p_credit_points OUT NOCOPY NUMBER )
243: RETURN NUMBER AS
244: BEGIN

Line 241: p_key_version_number IN igs_en_su_attempt.version_number%TYPE,

237: p_load_sequence_number IN NUMBER ,
238: p_truncate_ind IN VARCHAR2 ,
239: p_include_research_ind IN VARCHAR2 ,
240: p_key_course_cd IN igs_en_su_attempt.course_cd%TYPE,
241: p_key_version_number IN igs_en_su_attempt.version_number%TYPE,
242: p_credit_points OUT NOCOPY NUMBER )
243: RETURN NUMBER AS
244: BEGIN
245: DECLARE

Line 282: FROM IGS_EN_SU_ATTEMPT sua,

278: sua.unit_attempt_status,
279: sua.discontinued_dt,
280: sua.uoo_id,
281: sua.no_assessment_ind
282: FROM IGS_EN_SU_ATTEMPT sua,
283: IGS_CA_INST_REL cir,
284: IGS_PS_UNIT_VER uv
285: WHERE sua.person_id = p_person_id AND
286: sua.course_cd = p_course_cd AND

Line 304: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,

300: sua.ci_sequence_number = cp_seq_num;
301:
302:
303: CURSOR c_sgcc_dai (
304: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
305: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE) IS
306: SELECT NVL( dai.absolute_val,
307: IGS_CA_GEN_001.CALP_GET_ALIAS_VAL (
308: dai.dt_alias,

Line 305: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE) IS

301:
302:
303: CURSOR c_sgcc_dai (
304: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
305: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE) IS
306: SELECT NVL( dai.absolute_val,
307: IGS_CA_GEN_001.CALP_GET_ALIAS_VAL (
308: dai.dt_alias,
309: dai.sequence_number,

Line 446: p_key_course_cd IN igs_en_su_attempt.course_cd%TYPE,

442: p_override_enrolled_cp IN NUMBER ,
443: p_override_eftsu IN NUMBER ,
444: p_truncate_ind IN VARCHAR2 ,
445: p_sca_cp_total IN NUMBER ,
446: p_key_course_cd IN igs_en_su_attempt.course_cd%TYPE,
447: p_key_version_number IN igs_en_su_attempt.version_number%TYPE,
448: p_credit_points OUT NOCOPY NUMBER ,
449: -- anilk, Audit special fee build
450: p_include_audit IN VARCHAR2)

Line 447: p_key_version_number IN igs_en_su_attempt.version_number%TYPE,

443: p_override_eftsu IN NUMBER ,
444: p_truncate_ind IN VARCHAR2 ,
445: p_sca_cp_total IN NUMBER ,
446: p_key_course_cd IN igs_en_su_attempt.course_cd%TYPE,
447: p_key_version_number IN igs_en_su_attempt.version_number%TYPE,
448: p_credit_points OUT NOCOPY NUMBER ,
449: -- anilk, Audit special fee build
450: p_include_audit IN VARCHAR2)
451: -------------------------------------------------------------------------------------------

Line 489: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;

485: v_sua_eftsu NUMBER;
486: v_trunc_eftsu NUMBER;
487: v_return_eftsu NUMBER;
488: v_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
489: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;
490: --dummy variable to pick up audit, billing, enrolled credit points
491: --due to signature change by EN308 Billing credit hours
492: l_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;
493: l_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;

Line 499: FROM IGS_EN_SU_ATTEMPT sua

495:
496: CURSOR c_uooid IS
497: SELECT sua.uoo_id,
498: NVL(sua.no_assessment_ind,'N')
499: FROM IGS_EN_SU_ATTEMPT sua
500: WHERE sua.person_id = p_person_id AND
501: sua.course_cd = p_course_cd AND
502: sua.uoo_id = p_uoo_id;
503:

Line 1108: FROM IGS_EN_SU_ATTEMPT SUA

1104: SUA.administrative_unit_status,
1105: SUA.discontinued_dt,
1106: SUA.uoo_id,
1107: SUA.no_assessment_ind
1108: FROM IGS_EN_SU_ATTEMPT SUA
1109: WHERE SUA.person_id = cp_person_id AND
1110: SUA.course_cd = cp_course_cd AND
1111: SUA.cal_type = cp_cal_type AND
1112: SUA.ci_sequence_number = cp_sequence_number AND

Line 1448: IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE) IS

1444: cp_load_cal_type IGS_CA_INST.cal_type%TYPE,
1445: cp_load_sequence_number IGS_CA_INST.sequence_number%TYPE,
1446: cp_cal_type IGS_CA_INST.cal_type%TYPE,
1447: cp_administrative_unit_status
1448: IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE) IS
1449: SELECT AUSL.load_incurred_ind
1450: FROM IGS_AD_ADM_UT_STT_LD AUSL
1451: WHERE AUSL.cal_type = cp_load_cal_type AND
1452: AUSL.ci_sequence_number = cp_load_sequence_number AND

Line 1667: p_version_number OUT NOCOPY igs_en_su_attempt.version_number%TYPE,

1663: END;
1664: END ENRP_GET_LOAD_APPLY;
1665:
1666: FUNCTION enrp_clc_key_prog(p_person_id IN hz_parties.party_id%TYPE,
1667: p_version_number OUT NOCOPY igs_en_su_attempt.version_number%TYPE,
1668: p_term_cal_type IN VARCHAR2,
1669: p_term_sequence_number IN NUMBER
1670: )
1671: RETURN igs_en_su_attempt.course_cd%TYPE

Line 1671: RETURN igs_en_su_attempt.course_cd%TYPE

1667: p_version_number OUT NOCOPY igs_en_su_attempt.version_number%TYPE,
1668: p_term_cal_type IN VARCHAR2,
1669: p_term_sequence_number IN NUMBER
1670: )
1671: RETURN igs_en_su_attempt.course_cd%TYPE
1672:
1673: /*******************************************************************************************
1674: Created By : Prajeesh Chandran .K
1675: Creation Date: 8-JAN-2002

Line 1757: p_credit_points OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE,

1753: PROCEDURE enrp_get_inst_latt(p_person_id IN hz_parties.party_id%TYPE,
1754: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1755: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE,
1756: p_attendance OUT NOCOPY igs_en_atd_type_load.attendance_type%TYPE,
1757: p_credit_points OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE,
1758: p_fte OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE
1759: )
1760: AS
1761:

Line 1758: p_fte OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE

1754: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1755: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE,
1756: p_attendance OUT NOCOPY igs_en_atd_type_load.attendance_type%TYPE,
1757: p_credit_points OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE,
1758: p_fte OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE
1759: )
1760: AS
1761:
1762: /*******************************************************************************************

Line 1794: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;

1790: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1791: l_acad_ci_start_dt igs_ca_inst.start_dt%TYPE;
1792: l_acad_ci_end_dt igs_ca_inst.end_dt%TYPE;
1793: l_message_name VARCHAR2(100) := NULL;
1794: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;
1795: l_tot_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;
1796: l_eftsu_total igs_en_su_attempt.override_eftsu%TYPE := 0;
1797: l_alternate_code igs_ca_inst.alternate_code%TYPE := NULL;
1798: l_course_cd igs_en_su_attempt.course_cd%TYPE;

Line 1795: l_tot_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;

1791: l_acad_ci_start_dt igs_ca_inst.start_dt%TYPE;
1792: l_acad_ci_end_dt igs_ca_inst.end_dt%TYPE;
1793: l_message_name VARCHAR2(100) := NULL;
1794: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;
1795: l_tot_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;
1796: l_eftsu_total igs_en_su_attempt.override_eftsu%TYPE := 0;
1797: l_alternate_code igs_ca_inst.alternate_code%TYPE := NULL;
1798: l_course_cd igs_en_su_attempt.course_cd%TYPE;
1799: l_version_number igs_en_su_attempt.version_number%TYPE;

Line 1796: l_eftsu_total igs_en_su_attempt.override_eftsu%TYPE := 0;

1792: l_acad_ci_end_dt igs_ca_inst.end_dt%TYPE;
1793: l_message_name VARCHAR2(100) := NULL;
1794: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;
1795: l_tot_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;
1796: l_eftsu_total igs_en_su_attempt.override_eftsu%TYPE := 0;
1797: l_alternate_code igs_ca_inst.alternate_code%TYPE := NULL;
1798: l_course_cd igs_en_su_attempt.course_cd%TYPE;
1799: l_version_number igs_en_su_attempt.version_number%TYPE;
1800: l_attendance_type igs_en_atd_type_load.attendance_type%TYPE;

Line 1798: l_course_cd igs_en_su_attempt.course_cd%TYPE;

1794: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;
1795: l_tot_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;
1796: l_eftsu_total igs_en_su_attempt.override_eftsu%TYPE := 0;
1797: l_alternate_code igs_ca_inst.alternate_code%TYPE := NULL;
1798: l_course_cd igs_en_su_attempt.course_cd%TYPE;
1799: l_version_number igs_en_su_attempt.version_number%TYPE;
1800: l_attendance_type igs_en_atd_type_load.attendance_type%TYPE;
1801:
1802:

Line 1799: l_version_number igs_en_su_attempt.version_number%TYPE;

1795: l_tot_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;
1796: l_eftsu_total igs_en_su_attempt.override_eftsu%TYPE := 0;
1797: l_alternate_code igs_ca_inst.alternate_code%TYPE := NULL;
1798: l_course_cd igs_en_su_attempt.course_cd%TYPE;
1799: l_version_number igs_en_su_attempt.version_number%TYPE;
1800: l_attendance_type igs_en_atd_type_load.attendance_type%TYPE;
1801:
1802:
1803: --## CURSOR to get the Person number for the person id for message tokens

Line 1937: p_credit_points OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE,

1933: PROCEDURE enrp_get_inst_latt_fte(p_person_id IN hz_parties.party_id%TYPE,
1934: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1935: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE,
1936: p_attendance OUT NOCOPY igs_en_atd_type_load.attendance_type%TYPE,
1937: p_credit_points OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE,
1938: p_fte OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE
1939: )
1940: AS
1941:

Line 1938: p_fte OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE

1934: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1935: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE,
1936: p_attendance OUT NOCOPY igs_en_atd_type_load.attendance_type%TYPE,
1937: p_credit_points OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE,
1938: p_fte OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE
1939: )
1940: AS
1941:
1942: /*******************************************************************************************

Line 1965: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;

1961: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1962: l_acad_ci_start_dt igs_ca_inst.start_dt%TYPE;
1963: l_acad_ci_end_dt igs_ca_inst.end_dt%TYPE;
1964: l_message_name VARCHAR2(100) := NULL;
1965: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;
1966: l_tot_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;
1967: l_eftsu_total igs_en_su_attempt.override_eftsu%TYPE := 0;
1968: l_alternate_code igs_ca_inst.alternate_code%TYPE := NULL;
1969: l_course_cd igs_en_su_attempt.course_cd%TYPE;

Line 1966: l_tot_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;

1962: l_acad_ci_start_dt igs_ca_inst.start_dt%TYPE;
1963: l_acad_ci_end_dt igs_ca_inst.end_dt%TYPE;
1964: l_message_name VARCHAR2(100) := NULL;
1965: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;
1966: l_tot_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;
1967: l_eftsu_total igs_en_su_attempt.override_eftsu%TYPE := 0;
1968: l_alternate_code igs_ca_inst.alternate_code%TYPE := NULL;
1969: l_course_cd igs_en_su_attempt.course_cd%TYPE;
1970: l_version_number igs_en_su_attempt.version_number%TYPE;

Line 1967: l_eftsu_total igs_en_su_attempt.override_eftsu%TYPE := 0;

1963: l_acad_ci_end_dt igs_ca_inst.end_dt%TYPE;
1964: l_message_name VARCHAR2(100) := NULL;
1965: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;
1966: l_tot_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;
1967: l_eftsu_total igs_en_su_attempt.override_eftsu%TYPE := 0;
1968: l_alternate_code igs_ca_inst.alternate_code%TYPE := NULL;
1969: l_course_cd igs_en_su_attempt.course_cd%TYPE;
1970: l_version_number igs_en_su_attempt.version_number%TYPE;
1971: l_attendance_type igs_en_atd_type_load.attendance_type%TYPE;

Line 1969: l_course_cd igs_en_su_attempt.course_cd%TYPE;

1965: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;
1966: l_tot_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;
1967: l_eftsu_total igs_en_su_attempt.override_eftsu%TYPE := 0;
1968: l_alternate_code igs_ca_inst.alternate_code%TYPE := NULL;
1969: l_course_cd igs_en_su_attempt.course_cd%TYPE;
1970: l_version_number igs_en_su_attempt.version_number%TYPE;
1971: l_attendance_type igs_en_atd_type_load.attendance_type%TYPE;
1972:
1973: CURSOR c_active_cd(l_career VARCHAR2) IS

Line 1970: l_version_number igs_en_su_attempt.version_number%TYPE;

1966: l_tot_credit_points igs_en_su_attempt.override_achievable_cp%TYPE := 0;
1967: l_eftsu_total igs_en_su_attempt.override_eftsu%TYPE := 0;
1968: l_alternate_code igs_ca_inst.alternate_code%TYPE := NULL;
1969: l_course_cd igs_en_su_attempt.course_cd%TYPE;
1970: l_version_number igs_en_su_attempt.version_number%TYPE;
1971: l_attendance_type igs_en_atd_type_load.attendance_type%TYPE;
1972:
1973: CURSOR c_active_cd(l_career VARCHAR2) IS
1974: SELECT course_cd,

Line 2174: FROM IGS_EN_SU_ATTEMPT sua,

2170: sua.unit_attempt_status,
2171: sua.discontinued_dt,
2172: sua.uoo_id,
2173: sua.no_assessment_ind
2174: FROM IGS_EN_SU_ATTEMPT sua,
2175: IGS_EN_STDNT_PS_ATT sca,
2176: IGS_PS_UNIT_VER uv
2177: WHERE
2178: sca.person_id = p_person_id AND

Line 2548: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE;

2544: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE
2545: ) RETURN VARCHAR2 AS
2546:
2547: l_attendance igs_en_atd_type_load.attendance_type%TYPE;
2548: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE;
2549: l_fte igs_en_su_attempt.override_achievable_cp%TYPE;
2550:
2551: BEGIN
2552:

Line 2549: l_fte igs_en_su_attempt.override_achievable_cp%TYPE;

2545: ) RETURN VARCHAR2 AS
2546:
2547: l_attendance igs_en_atd_type_load.attendance_type%TYPE;
2548: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE;
2549: l_fte igs_en_su_attempt.override_achievable_cp%TYPE;
2550:
2551: BEGIN
2552:
2553: enrp_get_inst_latt(p_person_id => p_person_id ,

Line 2578: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE;

2574: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE
2575: ) RETURN VARCHAR2 AS
2576:
2577: l_attendance igs_en_atd_type_load.attendance_type%TYPE;
2578: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE;
2579: l_fte igs_en_su_attempt.override_achievable_cp%TYPE;
2580:
2581: BEGIN
2582:

Line 2579: l_fte igs_en_su_attempt.override_achievable_cp%TYPE;

2575: ) RETURN VARCHAR2 AS
2576:
2577: l_attendance igs_en_atd_type_load.attendance_type%TYPE;
2578: l_credit_points igs_en_su_attempt.override_achievable_cp%TYPE;
2579: l_fte igs_en_su_attempt.override_achievable_cp%TYPE;
2580:
2581: BEGIN
2582:
2583: enrp_get_inst_latt(p_person_id => p_person_id ,

Line 2614: FROM IGS_EN_SU_ATTEMPT sua,

2610: cp_c_program IN VARCHAR2,
2611: cp_c_load_cal IN VARCHAR2,
2612: cp_n_load_seq_num IN NUMBER) IS
2613: SELECT NVL(SUM(igs_ss_enr_details.get_apor_credits ( uoo_id, override_enrolled_cp,ca.load_cal_type,ca.load_ci_sequence_number)),0) apor_cp
2614: FROM IGS_EN_SU_ATTEMPT sua,
2615: IGS_CA_TEACH_TO_LOAD_V ca
2616: WHERE sua.unit_attempt_status = 'UNCONFIRM'
2617: AND sua.person_id = cp_n_perosn_id
2618: AND sua.course_cd = cp_c_program