APPS.IGS_EN_GEN_LEGACY dependencies on IGS_PS_UNIT_OFR_OPT

Line 312: FROM IGS_PS_UNIT_OFR_OPT

308: --
309: -- Cursor to derive uoo_id
310: CURSOR get_uoo_id IS
311: SELECT uoo_id , owner_org_unit_cd
312: FROM IGS_PS_UNIT_OFR_OPT
313: WHERE unit_cd = p_unit_cd AND
314: version_number = p_version_number AND
315: cal_type = p_cal_type AND
316: ci_sequence_number = p_ci_sequence_number AND

Line 321: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;

317: location_cd = p_location_cd AND
318: unit_class = p_unit_class;
319:
320: l_org_unit_cd igs_or_unit.org_unit_cd%TYPE;
321: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
322:
323: BEGIN
324: -- Derive uoo_id
325: OPEN get_uoo_id ;

Line 364: FROM igs_ps_unit_ofr_opt

360: --
361: -- Cursor to derive Unit version Number
362: CURSOR get_unit_ver IS
363: SELECT version_number
364: FROM igs_ps_unit_ofr_opt
365: WHERE cal_type = p_cal_type AND
366: unit_cd = p_unit_cd AND
367: ci_sequence_number = p_ci_sequence_number AND
368: location_cd = p_location_cd AND

Line 375: FROM igs_ps_unit_ofr_opt

371: --
372: -- Cursor to find count of matching Unit version Number(s)
373: CURSOR get_unit_ver_count IS
374: SELECT COUNT(*)
375: FROM igs_ps_unit_ofr_opt
376: WHERE cal_type = p_cal_type AND
377: unit_cd = p_unit_cd AND
378: ci_sequence_number = p_ci_sequence_number AND
379: location_cd = p_location_cd AND