APPS.IGS_AD_CANCEL_RECONSIDER dependencies on HZ_PARTIES

Line 28: FUNCTION get_person_number ( p_person_id hz_parties.party_id%TYPE ) RETURN VARCHAR2 IS

24: | Person ID Group |
25: | (Enh# 3194295 , ADCR043: Person ID Group) |
26: *=======================================================================*/
27:
28: FUNCTION get_person_number ( p_person_id hz_parties.party_id%TYPE ) RETURN VARCHAR2 IS
29:
30: CURSOR c_person_num IS
31: SELECT party_number
32: FROM hz_parties hp

Line 32: FROM hz_parties hp

28: FUNCTION get_person_number ( p_person_id hz_parties.party_id%TYPE ) RETURN VARCHAR2 IS
29:
30: CURSOR c_person_num IS
31: SELECT party_number
32: FROM hz_parties hp
33: WHERE hp.party_id = p_person_id;
34:
35: lv_person_number hz_parties.party_number%TYPE DEFAULT NULL;
36: BEGIN

Line 35: lv_person_number hz_parties.party_number%TYPE DEFAULT NULL;

31: SELECT party_number
32: FROM hz_parties hp
33: WHERE hp.party_id = p_person_id;
34:
35: lv_person_number hz_parties.party_number%TYPE DEFAULT NULL;
36: BEGIN
37:
38: OPEN c_person_num;
39: FETCH c_person_num INTO lv_person_number;