APPS.IGS_PS_GEN_008 dependencies on IGS_PS_UOFR_WLST_PRI

Line 1781: FROM igs_ps_uofr_wlst_pri

1777: AS
1778:
1779: CURSOR c_uofr_wlst_pri_det IS
1780: SELECT *
1781: FROM igs_ps_uofr_wlst_pri
1782: WHERE unit_cd = p_unit_cd
1783: AND version_number = p_version_number
1784: AND calender_type = p_cal_type
1785: AND ci_sequence_number= p_ci_sequence_number;

Line 1787: v_unit_ofr_wlist_pri_id igs_ps_uofr_wlst_pri.unit_ofr_waitlist_priority_id%TYPE;

1783: AND version_number = p_version_number
1784: AND calender_type = p_cal_type
1785: AND ci_sequence_number= p_ci_sequence_number;
1786:
1787: v_unit_ofr_wlist_pri_id igs_ps_uofr_wlst_pri.unit_ofr_waitlist_priority_id%TYPE;
1788:
1789: CURSOR c_uofr_wlst_prf_det(cp_unit_ofr_wlst_priority_id igs_ps_uofr_wlst_prf.unit_ofr_waitlist_priority_id%TYPE) IS
1790: SELECT *
1791: FROM igs_ps_uofr_wlst_prf

Line 1802: igs_ps_uofr_wlst_pri_pkg.Insert_Row(

1798: FOR c_uofr_wlst_pri_rec IN c_uofr_wlst_pri_det
1799: LOOP
1800: x_rowid := NULL;
1801: v_unit_ofr_wlist_pri_id := NULL;
1802: igs_ps_uofr_wlst_pri_pkg.Insert_Row(
1803: x_rowid => x_rowid,
1804: x_unit_ofr_wl_priority_id => v_unit_ofr_wlist_pri_id,
1805: x_unit_cd => p_new_unit_cd,
1806: x_version_number => p_new_version_number,