APPS.IGR_PERSON_TYPE_PKG dependencies on IGS_PE_PERSON_TYPES

Line 17: l_person_type_code igs_pe_person_types.person_type_code%TYPE;

13: cst_evaluator CONSTANT varchar2(50) := 'EVALUATOR';
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);

Line 24: CURSOR c_person_type_code(l_system_type IGS_PE_PERSON_TYPES.system_type%TYPE) IS

20: lv_sysdate DATE;
21: l_org_id NUMBER(15);
22: lv_rowid2 VARCHAR2(30);
23:
24: CURSOR c_person_type_code(l_system_type IGS_PE_PERSON_TYPES.system_type%TYPE) IS
25: SELECT person_type_code
26: FROM igs_pe_person_types
27: WHERE system_type=l_system_type;
28:

Line 26: FROM igs_pe_person_types

22: lv_rowid2 VARCHAR2(30);
23:
24: CURSOR c_person_type_code(l_system_type IGS_PE_PERSON_TYPES.system_type%TYPE) IS
25: SELECT person_type_code
26: FROM igs_pe_person_types
27: WHERE system_type=l_system_type;
28:
29: BEGIN
30: l_org_id := igs_ge_gen_003.get_org_id;

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