APPS.IGS_PR_GEN_005 dependencies on HZ_PARTIES

Line 927: FROM hz_parties

923: AND spc.spo_sequence_number = pl_spo_sequence_number
924: AND spc.course_cd = p_course_cd;
925: CURSOR c_person (cp_party_id NUMBER) IS
926: SELECT party_number
927: FROM hz_parties
928: WHERE party_id = cp_party_id;
929: lv_person_number hz_parties.party_number%TYPE;
930: BEGIN
931: OPEN c_spc;

Line 929: lv_person_number hz_parties.party_number%TYPE;

925: CURSOR c_person (cp_party_id NUMBER) IS
926: SELECT party_number
927: FROM hz_parties
928: WHERE party_id = cp_party_id;
929: lv_person_number hz_parties.party_number%TYPE;
930: BEGIN
931: OPEN c_spc;
932: FETCH c_spc INTO v_dummy;
933: IF c_spc%FOUND THEN

Line 981: FROM hz_parties

977: AND cgm.version_number = p_version_number
978: AND course_group_cd = pl_encmb_course_group_cd;
979: CURSOR c_person (cp_party_id NUMBER) IS
980: SELECT party_number
981: FROM hz_parties
982: WHERE party_id = cp_party_id;
983: lv_person_number hz_parties.party_number%TYPE;
984: BEGIN
985: IF pl_encmb_course_group_cd IS NOT NULL THEN

Line 983: lv_person_number hz_parties.party_number%TYPE;

979: CURSOR c_person (cp_party_id NUMBER) IS
980: SELECT party_number
981: FROM hz_parties
982: WHERE party_id = cp_party_id;
983: lv_person_number hz_parties.party_number%TYPE;
984: BEGIN
985: IF pl_encmb_course_group_cd IS NOT NULL THEN
986: OPEN c_cgm;
987: FETCH c_cgm INTO v_dummy;