DBA Data[Home] [Help]

APPS.IGR_PER_INFO_001 dependencies on IGS_AD_I_PRG_U_SET

Line 56: IGS_AD_I_PRG_U_SET USET,

52: FUNCTION GET_INQ_PROG_UNIT_SETS(x_prog_pref_id IN NUMBER) RETURN VARCHAR2 IS
53: CURSOR cur_unit_sets IS
54: SELECT CODE.DESCRIPTION
55: FROM IGS_AD_I_PRG_PRF_UST PREF,
56: IGS_AD_I_PRG_U_SET USET,
57: IGS_AD_INQ_UNIT_SETS CODE
58: WHERE PREF.INQ_PROG_UNIT_SET_ID = USET.INQ_PROG_UNIT_SET_ID
59: AND USET.INQ_UNIT_SET_CODE_ID = CODE.INQ_UNIT_SET_CODE_ID
60: AND PREF.INQ_PROG_PREF_ID =x_prog_pref_id;