APPS.IGS_PS_GEN_001 dependencies on IGS_PS_USO_FACILITY

Line 2325: CURSOR usec_fac(cp_unit_section_occurrence_id igs_ps_uso_facility.unit_section_occurrence_id%TYPE) IS

2321: SELECT *
2322: FROM igs_ps_nsus_rtn_dtl
2323: WHERE non_std_usec_rtn_id = cp_non_std_usec_rtn_id;
2324:
2325: CURSOR usec_fac(cp_unit_section_occurrence_id igs_ps_uso_facility.unit_section_occurrence_id%TYPE) IS
2326: SELECT *
2327: FROM igs_ps_uso_facility
2328: WHERE unit_section_occurrence_id = cp_unit_section_occurrence_id;
2329:

Line 2327: FROM igs_ps_uso_facility

2323: WHERE non_std_usec_rtn_id = cp_non_std_usec_rtn_id;
2324:
2325: CURSOR usec_fac(cp_unit_section_occurrence_id igs_ps_uso_facility.unit_section_occurrence_id%TYPE) IS
2326: SELECT *
2327: FROM igs_ps_uso_facility
2328: WHERE unit_section_occurrence_id = cp_unit_section_occurrence_id;
2329:
2330: CURSOR c_fee_type_cal_exists(cp_c_source_fee_type igs_fi_fee_type.fee_type%TYPE) IS
2331: SELECT ci.cal_type,ci.sequence_number

Line 2881: igs_ps_uso_facility_pkg.insert_row (

2877: DECLARE
2878: lv_rowid VARCHAR2(25);
2879: l_uso_facility_id NUMBER;
2880: BEGIN
2881: igs_ps_uso_facility_pkg.insert_row (
2882: x_rowid => lv_rowid,
2883: x_uso_facility_id => l_uso_facility_id,
2884: x_unit_section_occurrence_id => l_usec_id,
2885: x_facility_code => usec_fac_rec.facility_code,