APPS.OKS_MASS_UPD_PVT dependencies on OKC_STATUSES_V

Line 60: from okc_statuses_v S, fnd_lookups ST

56: l_string VARCHAR2(300);
57:
58: CURSOR get_statuses(p_old_ste_code VARCHAR2) IS
59: select S.STE_CODE STE_CODE1
60: from okc_statuses_v S, fnd_lookups ST
61: where S.STE_CODE in (NVL(p_old_ste_code, 'ENTERED'),
62: decode(p_old_ste_code,
63: NULL,
64: 'CANCELLED',

Line 3363: (SELECT ste_code FROM okc_statuses_v WHERE code = global_status AND ROWNUM=1) global_status_code,

3359: global_start_date,
3360: global_end_date,
3361: global_price_negotiated,
3362: global_status,
3363: (SELECT ste_code FROM okc_statuses_v WHERE code = global_status AND ROWNUM=1) global_status_code,
3364: global_reason_code,
3365: global_comments
3366: FROM oks_headers_temp
3367: WHERE chr_id = p_contract_id;