APPS.IGF_AP_MATCHING_PROCESS_PKG dependencies on IGS_PE_TYP_INSTANCES_ALL

Line 3090: ln_typ_id igs_pe_typ_instances_all.type_instance_id%TYPE;

3086: l_rowid ROWID;
3087: l_adm_seq igs_ca_inst.sequence_number%TYPE;
3088: l_acad_cal_type igs_ca_type.cal_type%TYPE;
3089: l_acad_seq igs_ca_inst.sequence_number%TYPE;
3090: ln_typ_id igs_pe_typ_instances_all.type_instance_id%TYPE;
3091: l_adm_alternate_code igs_ca_inst.alternate_code%TYPE;
3092: l_message VARCHAR2(255);
3093: lv_return_status VARCHAR2(255);
3094: lv_msg_data VARCHAR2(2000);

Line 8201: FROM igs_pe_typ_instances_all pti,

8197: */
8198:
8199: CURSOR cur_ptyp_code IS
8200: SELECT COUNT(*)
8201: FROM igs_pe_typ_instances_all pti,
8202: igs_pe_person_types pt
8203: WHERE pti.person_id = p_person_id
8204: AND pti.person_type_code = pt.person_type_code
8205: AND SYSDATE BETWEEN pti.start_date and NVL(pti.end_date,SYSDATE)