APPS.IGS_AD_VAL_AUOS dependencies on IGS_AD_UNIT_OU_STAT

Line 94: --This module Checks if another IGS_AD_UNIT_OU_STAT record

90: p_message_name OUT NOCOPY VARCHAR2 )
91: RETURN BOOLEAN IS
92: gv_other_detail VARCHAR2(255);
93: BEGIN --admp_val_auos_dflt
94: --This module Checks if another IGS_AD_UNIT_OU_STAT record
95: --exists with the system default indicator set to 'Y'.
96: DECLARE
97: v_auos_exists VARCHAR2(1);
98: CURSOR c_auos IS

Line 100: FROM IGS_AD_UNIT_OU_STAT auos

96: DECLARE
97: v_auos_exists VARCHAR2(1);
98: CURSOR c_auos IS
99: SELECT 'X'
100: FROM IGS_AD_UNIT_OU_STAT auos
101: WHERE auos.adm_unit_outcome_status <> p_adm_unit_outcome_status AND
102: auos.s_adm_outcome_status = p_s_adm_outcome_status AND
103: auos.system_default_ind = 'Y';
104: BEGIN