APPS.IGS_OR_INST_IMP_003_PKG dependencies on IGS_PE_TYP_INSTANCES_ALL

Line 310: l_org_id igs_pe_typ_instances_all.org_id%TYPE;

306: l_party_last_update_date DATE;
307: l_org_cont_last_update_date DATE;
308: l_org_contact_id igs_or_contacts_v.org_contact_id%TYPE;
309: l_or_cont_id igs_or_contacts_v.org_contact_id%TYPE;
310: l_org_id igs_pe_typ_instances_all.org_id%TYPE;
311: l_instance_id igs_pe_typ_instances.type_instance_id%TYPE;
312: l_contact_point_id igs_or_contacts_v.org_contact_id%TYPE;
313: l_contact_number igs_or_contacts_v.contact_number%TYPE;
314: l_cont_dml_operation VARCHAR2(10);

Line 446: FROM igs_pe_typ_instances_all

442:
443: --Cursor to fetch person type
444: CURSOR cur_person_type(cp_contact_party_id igs_or_inst_con_int.contact_party_id%TYPE) IS
445: SELECT person_type_code
446: FROM igs_pe_typ_instances_all
447: WHERE person_id = cp_contact_party_id AND
448: SYSDATE BETWEEN start_date AND NVL(end_date,SYSDATE);
449:
450: p_status VARCHAR2(1);