APPS.IGS_EN_VAL_USFT dependencies on IGS_EN_UNIT_SET

Line 305: p_unit_set_cd IN IGS_EN_UNIT_SET_ALL.unit_set_cd%TYPE ,

301: -- To validate the calendar instance system cal status is not 'INACTIVE'
302:
303: FUNCTION FINP_VAL_US_STATUS(
304:
305: p_unit_set_cd IN IGS_EN_UNIT_SET_ALL.unit_set_cd%TYPE ,
306:
307: p_version_number IN IGS_EN_UNIT_SET_ALL.version_number%TYPE ,
308:
309: p_message_name OUT NOCOPY VARCHAR2)

Line 307: p_version_number IN IGS_EN_UNIT_SET_ALL.version_number%TYPE ,

303: FUNCTION FINP_VAL_US_STATUS(
304:
305: p_unit_set_cd IN IGS_EN_UNIT_SET_ALL.unit_set_cd%TYPE ,
306:
307: p_version_number IN IGS_EN_UNIT_SET_ALL.version_number%TYPE ,
308:
309: p_message_name OUT NOCOPY VARCHAR2)
310: RETURN boolean AS
311:

Line 322: CURSOR c_us ( cp_unit_set_cd IGS_EN_UNIT_SET.unit_set_cd%TYPE,

318: DECLARE
319:
320: v_dummy VARCHAR2(1);
321:
322: CURSOR c_us ( cp_unit_set_cd IGS_EN_UNIT_SET.unit_set_cd%TYPE,
323:
324: cp_version_number IGS_EN_UNIT_SET.version_number%TYPE) IS
325:
326: SELECT 'X'

Line 324: cp_version_number IGS_EN_UNIT_SET.version_number%TYPE) IS

320: v_dummy VARCHAR2(1);
321:
322: CURSOR c_us ( cp_unit_set_cd IGS_EN_UNIT_SET.unit_set_cd%TYPE,
323:
324: cp_version_number IGS_EN_UNIT_SET.version_number%TYPE) IS
325:
326: SELECT 'X'
327:
328: FROM IGS_EN_UNIT_SET us,

Line 328: FROM IGS_EN_UNIT_SET us,

324: cp_version_number IGS_EN_UNIT_SET.version_number%TYPE) IS
325:
326: SELECT 'X'
327:
328: FROM IGS_EN_UNIT_SET us,
329:
330: IGS_EN_UNIT_SET_STAT uss
331:
332: WHERE us.unit_set_cd = p_unit_set_cd AND

Line 330: IGS_EN_UNIT_SET_STAT uss

326: SELECT 'X'
327:
328: FROM IGS_EN_UNIT_SET us,
329:
330: IGS_EN_UNIT_SET_STAT uss
331:
332: WHERE us.unit_set_cd = p_unit_set_cd AND
333:
334: us.version_number = p_version_number AND