APPS.IGS_AS_ADI_UPLD_AIO_PKG dependencies on HZ_PARTIES

Line 616: FROM hz_parties hzp

612: --
613: --
614: CURSOR c_person_id IS
615: SELECT party_id
616: FROM hz_parties hzp
617: WHERE hzp.party_number = p_person_number;
618: --
619: --
620: --

Line 671: cp_person_id hz_parties.party_id%TYPE

667: --
668: CURSOR c_uoo_id (
669: cp_cal_type igs_en_su_attempt_all.cal_type%TYPE,
670: cp_ci_sequence_number igs_en_su_attempt_all.ci_sequence_number%TYPE,
671: cp_person_id hz_parties.party_id%TYPE
672: ) IS
673: SELECT uoo_id
674: FROM igs_en_su_attempt_all
675: WHERE unit_cd = p_unit_cd

Line 685: CURSOR c_course_attempt_status (cp_person_id hz_parties.party_id%TYPE) IS

681: AND location_cd = p_location_cd;
682: --
683: --
684: --
685: CURSOR c_course_attempt_status (cp_person_id hz_parties.party_id%TYPE) IS
686: SELECT course_attempt_status
687: FROM igs_en_stdnt_ps_att_all
688: WHERE person_id = cp_person_id
689: AND course_cd = p_course_cd;

Line 709: cp_person_id hz_parties.party_id%TYPE,

705: --
706: CURSOR c_ass_item_exist (
707: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,
708: cp_ass_id igs_as_assessmnt_itm.ass_id%TYPE,
709: cp_person_id hz_parties.party_id%TYPE,
710: cp_reference VARCHAR2
711: ) IS
712: SELECT 'X'
713: FROM igs_as_su_atmpt_itm sai

Line 725: cp_person_id hz_parties.party_id%TYPE,

721: --
722: --
723: CURSOR c_ass_item_grade_exist (
724: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,
725: cp_person_id hz_parties.party_id%TYPE,
726: cp_ass_id igs_as_assessmnt_itm.ass_id%TYPE,
727: cp_reference VARCHAR2
728: ) IS
729: SELECT sai.outcome_dt outcome_dt