APPS.IGS_EN_ADD_UNITS_API dependencies on IGS_PE_PERSON_TYPES

Line 407: FROM igs_pe_person_types

403:
404: -- cursor to get person type
405: CURSOR cur_per_typ IS
406: SELECT person_type_code
407: FROM igs_pe_person_types
408: WHERE system_type = 'OTHER';
409:
410: l_cur_per_typ igs_pe_typ_instances.person_type_code%TYPE;
411: lv_person_type igs_pe_typ_instances.person_type_code%TYPE;

Line 2745: FROM igs_pe_person_types

2741:
2742: -- cursor to get the system person type
2743: CURSOR cur_sys_pers_type IS
2744: SELECT system_type
2745: FROM igs_pe_person_types
2746: WHERE person_type_code = g_person_type;
2747:
2748: -- cursor to get the unit code and unit class
2749: CURSOR c_sua_exists(cp_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE) IS

Line 2783: l_sys_per_type igs_pe_person_types.system_type%TYPE;

2779: l_unit_dtsl_rec c_unit_dtls%ROWTYPE;
2780: l_enc_message_name VARCHAR2(2000);
2781: l_app_short_name VARCHAR2(100);
2782: l_msg_index NUMBER;
2783: l_sys_per_type igs_pe_person_types.system_type%TYPE;
2784: l_en_cpd_ext_rec igs_en_cpd_ext%ROWTYPE;
2785: l_message_name VARCHAR2(100);
2786: l_deny_warn igs_en_cpd_ext.notification_flag%TYPE;
2787: p_rule_failed BOOLEAN;