APPS.IGS_PR_GEN_004 dependencies on HZ_PARTIES

Line 6479: SELECT PARTY_NUMBER FROM HZ_PARTIES

6475: cgm.course_cd = sca.course_cd AND
6476: cgm.version_number = sca.version_number)))));
6477:
6478: CURSOR c_person(cp_party_id Number) IS
6479: SELECT PARTY_NUMBER FROM HZ_PARTIES
6480: WHERE PARTY_ID = cp_party_id;
6481:
6482: lv_person_number HZ_PARTIES.PARTY_NUMBER%TYPE;
6483: BEGIN

Line 6482: lv_person_number HZ_PARTIES.PARTY_NUMBER%TYPE;

6478: CURSOR c_person(cp_party_id Number) IS
6479: SELECT PARTY_NUMBER FROM HZ_PARTIES
6480: WHERE PARTY_ID = cp_party_id;
6481:
6482: lv_person_number HZ_PARTIES.PARTY_NUMBER%TYPE;
6483: BEGIN
6484: -- Check for students whose expiry date is now available ; set where
6485: -- appropriate
6486: retcode := 0;