DBA Data[Home] [Help]

APPS.IGS_CA_VAL_DAIOC dependencies on IGS_LOOKUPS_VIEW

Line 386: v_closed_ind IGS_LOOKUPS_VIEW.closed_ind%TYPE;

382: RETURN BOOLEAN AS
383: gv_other_detail VARCHAR2(255);
384: BEGIN
385: DECLARE
386: v_closed_ind IGS_LOOKUPS_VIEW.closed_ind%TYPE;
387: CURSOR c_sdoct IS
388: SELECT sdoct.closed_ind
389: FROM IGS_LOOKUPS_VIEW sdoct
390: WHERE sdoct.LOOKUP_CODE = p_s_dt_offset_constraint_type

Line 389: FROM IGS_LOOKUPS_VIEW sdoct

385: DECLARE
386: v_closed_ind IGS_LOOKUPS_VIEW.closed_ind%TYPE;
387: CURSOR c_sdoct IS
388: SELECT sdoct.closed_ind
389: FROM IGS_LOOKUPS_VIEW sdoct
390: WHERE sdoct.LOOKUP_CODE = p_s_dt_offset_constraint_type
391: AND sdoct.LOOKUP_TYPE = 'DT_OFFSET_CONSTRAINT_TYPE';
392: BEGIN
393: -- Validate if S_DT_OFFSET_CONSTRAINT_TYPE.s_dt_offset_constraint_type