APPS.IGR_PERSON_TYPE_PKG dependencies on IGS_PE_TYP_INSTANCES_ALL

Line 18: l_funnel_status igs_pe_typ_instances_all.funnel_status%TYPE;

14: cst_funnel_status CONSTANT varchar2(25):= '100-IDENTIFIED';
15:
16: lv_type_instance_id NUMBER(15);
17: l_person_type_code igs_pe_person_types.person_type_code%TYPE;
18: l_funnel_status igs_pe_typ_instances_all.funnel_status%TYPE;
19:
20: lv_sysdate DATE;
21: l_org_id NUMBER(15);
22: lv_rowid2 VARCHAR2(30);

Line 99: igs_pe_typ_instances_all pti, igs_pe_person_types pt

95: CURSOR c_persontype_exist (cp_person_id igs_pe_typ_instances.person_id%TYPE)
96: IS
97: SELECT 'X'
98: FROM
99: igs_pe_typ_instances_all pti, igs_pe_person_types pt
100: WHERE
101: pti.person_id = cp_person_id
102: AND pti.person_type_code = pt.person_type_code
103: AND pt.system_type = p_person_type