APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_LOOKUP_VALUES

Line 552: CURSOR cur_credit_point_des(cp_credit_point_descriptor igs_lookup_values.lookup_code%TYPE) IS

548: smvk 20-Dec-2002 Removed the IGS_PS_UNIT_VER_PKG.check_constraints call of owner_org_unit_cd.
549: As owner org unit code can have value in mixed case. Bug 2487149.
550: ***********************************************************************************************/
551:
552: CURSOR cur_credit_point_des(cp_credit_point_descriptor igs_lookup_values.lookup_code%TYPE) IS
553: SELECT 'X'
554: FROM igs_lookup_values
555: WHERE lookup_type='CREDIT_POINT_DSCR'
556: AND lookup_code=cp_credit_point_descriptor;

Line 554: FROM igs_lookup_values

550: ***********************************************************************************************/
551:
552: CURSOR cur_credit_point_des(cp_credit_point_descriptor igs_lookup_values.lookup_code%TYPE) IS
553: SELECT 'X'
554: FROM igs_lookup_values
555: WHERE lookup_type='CREDIT_POINT_DSCR'
556: AND lookup_code=cp_credit_point_descriptor;
557: l_var VARCHAR2(1);
558: