APPS.IGS_PS_VAL_UV dependencies on IGS_PS_UNIT_OFR_OPT_ALL

Line 1224: p_uoo_id IN IGS_PS_UNIT_OFR_OPT_ALL.uoo_id%TYPE,

1220: END crsp_val_uv_ttl_ovrd;
1221:
1222:
1223: PROCEDURE get_cp_values(
1224: p_uoo_id IN IGS_PS_UNIT_OFR_OPT_ALL.uoo_id%TYPE,
1225: p_enrolled_cp OUT NOCOPY IGS_PS_USEC_CPS.enrolled_credit_points%TYPE,
1226: p_billable_cp OUT NOCOPY IGS_PS_USEC_CPS.billing_hrs%TYPE,
1227: p_audit_cp OUT NOCOPY IGS_PS_USEC_CPS.billing_credit_points%TYPE) AS
1228: /***********************************************************************************************

Line 1245: CURSOR c_uv(cp_uoo_id IN IGS_PS_UNIT_OFR_OPT_ALL.uoo_id%TYPE) IS

1241: l_uoo_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;
1242: l_uoo_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;
1243:
1244: -- fetches Enrolled, Audit and Billable credit point values from unit version table for given uoo_id
1245: CURSOR c_uv(cp_uoo_id IN IGS_PS_UNIT_OFR_OPT_ALL.uoo_id%TYPE) IS
1246: SELECT
1247: uv.enrolled_credit_points,
1248: uv.billing_hrs,
1249: uv.billing_credit_points

Line 1259: CURSOR c_uoo(cp_uoo_id IN IGS_PS_UNIT_OFR_OPT_ALL.uoo_id%TYPE) IS

1255: uoo.unit_cd = uv.unit_cd AND
1256: uoo.version_number = uv.version_number;
1257:
1258: -- fetches Enrolled, Audit and Billable credit point values from unit section table for given uoo_id
1259: CURSOR c_uoo(cp_uoo_id IN IGS_PS_UNIT_OFR_OPT_ALL.uoo_id%TYPE) IS
1260: SELECT
1261: us.enrolled_credit_points,
1262: us.billing_hrs,
1263: us.billing_credit_points