APPS.OKE_CHANGE_STATUS_PUB dependencies on DUAL

Line 156: select 'Y' from dual where (p_new_sts_code,p_new_ste_code) in

152: p_old_ste_code VARCHAR2,
153: p_start_date DATE,
154: p_end_date date
155: ) is
156: select 'Y' from dual where (p_new_sts_code,p_new_ste_code) in
157: (select
158: S.CODE STATUS_CODE
159: ,S.STE_CODE STE_CODE
160: from