APPS.IGS_PE_PER_TYPE_MAP_PKG dependencies on HZ_PARTIES

Line 261: CURSOR staff_exist (cp_person_id HZ_PARTIES.PARTY_ID%TYPE) IS

257: pt.system_type = cp_system_type AND
258: (ti.end_date IS NULL OR (SYSDATE BETWEEN ti.start_date AND ti.end_date))
259: ;
260: --skpandey, Bug#4937960: Changed staff_exist cursor definition to optimize query
261: CURSOR staff_exist (cp_person_id HZ_PARTIES.PARTY_ID%TYPE) IS
262: SELECT '1'
263: FROM igs_pe_typ_instances
264: WHERE person_id = cp_person_id
265: AND system_type = 'STAFF'

Line 269: CURSOR ss_cur (cp_person_id HZ_PARTIES.PARTY_ID%TYPE) IS

265: AND system_type = 'STAFF'
266: AND (end_date IS NULL OR (SYSDATE BETWEEN start_date AND end_date));
267:
268:
269: CURSOR ss_cur (cp_person_id HZ_PARTIES.PARTY_ID%TYPE) IS
270: SELECT ti.rowid,ti.*
271: FROM igs_pe_typ_instances_all ti,
272: igs_pe_person_types pt
273: WHERE ti.person_type_code = pt.person_type_code AND