APPS.IGS_SS_ENR_DETAILS dependencies on IGS_PE_PERSON_TYPES

Line 1468: FROM igs_pe_person_types

1464: */
1465: CURSOR cur_person_types
1466: IS
1467: SELECT system_type
1468: FROM igs_pe_person_types
1469: WHERE person_type_code = p_person_type;
1470:
1471:
1472: TYPE l_program_steps_rec IS RECORD (

Line 1481: l_system_person_type igs_pe_person_types.system_type%TYPE;

1477:
1478: l_cur_program_steps cur_program_steps%ROWTYPE;
1479: l_cur_person_types cur_person_types%ROWTYPE;
1480: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
1481: l_system_person_type igs_pe_person_types.system_type%TYPE;
1482: l_pig_deny_warn igs_en_cpd_ext.notification_flag%TYPE;
1483: l_message fnd_new_messages.message_name%TYPE;
1484:
1485: BEGIN

Line 4402: FROM igs_pe_person_types

4398: cir.sub_ci_sequence_number = cp_load_seq_num;
4399:
4400: CURSOR cur_sys_pers_type(p_person_type_code VARCHAR2) IS
4401: SELECT system_type
4402: FROM igs_pe_person_types
4403: WHERE person_type_code = p_person_type_code;
4404:
4405:
4406: l_rec c_get_load_cal_open_status%ROWTYPE;

Line 4408: l_system_type igs_pe_person_types.system_type%TYPE;

4404:
4405:
4406: l_rec c_get_load_cal_open_status%ROWTYPE;
4407: l_load_acad_rec c_check_is_load_assoc_to_acad%ROWTYPE;
4408: l_system_type igs_pe_person_types.system_type%TYPE;
4409:
4410: BEGIN
4411:
4412: OPEN cur_sys_pers_type(p_person_type);

Line 4692: FROM igs_pe_person_types

4688: AND term_sequence_number=cp_load_seq_num;
4689:
4690: CURSOR cur_sys_pers_type(p_person_type_code VARCHAR2) IS
4691: SELECT system_type
4692: FROM igs_pe_person_types
4693: WHERE person_type_code = p_person_type_code;
4694:
4695:
4696: l_plan_dt_alias igs_en_cal_conf.planning_open_dt_alias %TYPE;

Line 4709: l_system_type igs_pe_person_types.system_type%TYPE;

4705: l_schedule_open BOOLEAN;
4706: l_calling_object VARCHAR2(100);
4707:
4708: l_spat_plan_flag igs_en_spa_terms.plan_sht_status%TYPE;
4709: l_system_type igs_pe_person_types.system_type%TYPE;
4710:
4711:
4712: BEGIN
4713: l_planning_open := FALSE;