Line 1811: select 'Y' INTO l_allowed_status from dual where (l_new_sts_code,l_new_ste_code) in
1807: l_new_ste_code := p_new_ste_code;
1808: end if;
1809:
1810: 1811: select 'Y' INTO l_allowed_status from dual where (l_new_sts_code,l_new_ste_code) in 1812: (select
1813: S.CODE STATUS_CODE
1814: ,S.STE_CODE STE_CODE
1815: from