APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_PS_UNIT_TYPE_LVL

Line 89: l_n_unit_type_id igs_ps_unit_type_lvl.unit_type_id%TYPE;

85: l_n_coord_person_id igs_ps_unit_ver_all.coord_person_id%TYPE;
86: l_d_owner_ou_start_dt igs_ps_unit_ver_all.owner_ou_start_dt%TYPE;
87: l_n_subtitle_id igs_ps_unit_ver_all.subtitle_id%TYPE;
88: l_n_rpt_fmly_id igs_ps_rpt_fmly.rpt_fmly_id%TYPE;
89: l_n_unit_type_id igs_ps_unit_type_lvl.unit_type_id%TYPE;
90: l_c_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE;
91: l_n_seq_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE;
92: l_c_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE;
93: l_n_seq_num_offer_load_cal igs_ps_unit_ver_all.sequence_num_offer_load_cal%TYPE;

Line 311: CURSOR c_unit_lvl(cp_level_code igs_ps_unit_type_lvl.level_code%TYPE) IS

307: record_exclusion_flag,ss_display_ind,special_permission_ind
308: smvk 26-Dec-2002 Bug # 2721495. Calling the procedure igs_ps_validate_lgcy_pkg.get_party_id
309: instead of function igs_ge_gen_003.get_person_id to derive the person id.
310: ***********************************************************************************************/
311: CURSOR c_unit_lvl(cp_level_code igs_ps_unit_type_lvl.level_code%TYPE) IS
312: SELECT unit_type_id
313: FROM igs_ps_unit_type_lvl
314: WHERE level_code=cp_level_code;
315:

Line 313: FROM igs_ps_unit_type_lvl

309: instead of function igs_ge_gen_003.get_person_id to derive the person id.
310: ***********************************************************************************************/
311: CURSOR c_unit_lvl(cp_level_code igs_ps_unit_type_lvl.level_code%TYPE) IS
312: SELECT unit_type_id
313: FROM igs_ps_unit_type_lvl
314: WHERE level_code=cp_level_code;
315:
316: CURSOR c_repeat_code(cp_repeat_code igs_ps_rpt_fmly.repeat_code%TYPE) IS
317: SELECT rpt_fmly_id