APPS.IGS_EN_HESA_PKG dependencies on IGS_PE_ADDR_V

Line 42: gv_addr_rec igs_pe_addr_v.postal_code%TYPE;

38: p_message OUT NOCOPY VARCHAR2,
39: p_status OUT NOCOPY NUMBER)
40:
41: AS
42: gv_addr_rec igs_pe_addr_v.postal_code%TYPE;
43:
44: CURSOR gc_stats_rec IS
45: SELECT hesa_st_spa_id,
46: course_cd,

Line 148: FROM igs_pe_addr_v a

144: gv_adm_rec gc_adm_rec%ROWTYPE;
145:
146: CURSOR gc_addr_rec IS
147: SELECT a.postal_code postal_code
148: FROM igs_pe_addr_v a
149: WHERE a.person_id = p_person_id
150: AND (a.status = 'A' AND SYSDATE BETWEEN NVL(a.start_dt,SYSDATE) AND NVL(a.end_dt,SYSDATE))
151: AND (EXISTS(SELECT 'X'
152: FROM igs_pe_partysiteuse_v b