APPS.IGS_EN_GEN_012 dependencies on HZ_PARTIES

Line 2523: CURSOR c_sci_rcond (cp_person_id hz_parties.party_id%TYPE,

2519: sca.discontinued_dt <= SYSDATE AND
2520: sca.course_attempt_status NOT IN ('DISCONTIN',
2521: 'DELETED');
2522: -- smaddali added cursor for build EN324 - bug#5091858
2523: CURSOR c_sci_rcond (cp_person_id hz_parties.party_id%TYPE,
2524: cp_course_cd igs_ps_ver.course_cd%TYPE,
2525: cp_start_dt DATE,
2526: cp_logical_del_dt DATE) IS
2527: SELECT hz.party_number

Line 2528: FROM igs_en_spi_rconds rc, hz_parties hz

2524: cp_course_cd igs_ps_ver.course_cd%TYPE,
2525: cp_start_dt DATE,
2526: cp_logical_del_dt DATE) IS
2527: SELECT hz.party_number
2528: FROM igs_en_spi_rconds rc, hz_parties hz
2529: WHERE rc.person_id = hz.party_id
2530: AND rc.person_id =cp_person_id
2531: AND rc.course_cd =cp_course_cd
2532: AND rc.start_dt =cp_start_dt

Line 2548: CURSOR c_person_number (cp_person_id HZ_PARTIES.PARTY_ID%TYPE) IS

2544: e_resource_busy_exception EXCEPTION;
2545: PRAGMA EXCEPTION_INIT(e_resource_busy_exception, -54);
2546: l_msg_text VARCHAR2(2000);
2547:
2548: CURSOR c_person_number (cp_person_id HZ_PARTIES.PARTY_ID%TYPE) IS
2549: SELECT PARTY_NUMBER
2550: FROM HZ_PARTIES
2551: WHERE party_id = cp_person_id;
2552:

Line 2550: FROM HZ_PARTIES

2546: l_msg_text VARCHAR2(2000);
2547:
2548: CURSOR c_person_number (cp_person_id HZ_PARTIES.PARTY_ID%TYPE) IS
2549: SELECT PARTY_NUMBER
2550: FROM HZ_PARTIES
2551: WHERE party_id = cp_person_id;
2552:
2553: l_person_number HZ_PARTIES.PARTY_NUMBER%TYPE;
2554:

Line 2553: l_person_number HZ_PARTIES.PARTY_NUMBER%TYPE;

2549: SELECT PARTY_NUMBER
2550: FROM HZ_PARTIES
2551: WHERE party_id = cp_person_id;
2552:
2553: l_person_number HZ_PARTIES.PARTY_NUMBER%TYPE;
2554:
2555: /****************************************************************************
2556: History
2557: Who When Why