APPS.OKS_BILL_REC_PUB dependencies on OKC_STATUSES_B

Line 4079: --And exists (Select 1 from okc_statuses_b osb,

4075: and a.opn_code = 'INVOICE'
4076: and a.allowed_yn = 'Y')
4077: OR
4078: (lines.sts_code = 'HOLD'));
4079: --And exists (Select 1 from okc_statuses_b osb,
4080: -- okc_k_headers_b hdr
4081: -- Where osb.ste_code <> 'HOLD'
4082: -- and osb.code = Hdr.sts_code ));
4083:

Line 4191: AND sts_code IN(SELECT code FROM okc_statuses_b where ste_code NOT IN('TERMINATED','EXPIRED','CANCELLED')); ---bug 12310525

4187: FROM okc_k_lines_b
4188: WHERE cle_id = p_cle_id
4189: AND lse_id in (7,8,9,10,11,13,35,25)
4190: /* Start changes For bug fix 6012384 (FP for 5990067) */
4191: AND sts_code IN(SELECT code FROM okc_statuses_b where ste_code NOT IN('TERMINATED','EXPIRED','CANCELLED')); ---bug 12310525
4192: --AND sts_code <> 'TERMINATED';
4193: /* End changes for bug fix 6012384 (FP for 5990067) */
4194:
4195: /* Added for BUG 3364773 */

Line 4206: AND sts_code IN(SELECT code FROM okc_statuses_b where ste_code NOT IN('TERMINATED','EXPIRED','CANCELLED')); ---bug 12310525

4202: --AND lse_id in (1,12,14,19)
4203: /* End changes for bug fix 6012384 (FP for 5990067) */
4204: AND cle_id is null
4205: /* Start changes For bug fix 6012384 (FP for 5990067) */
4206: AND sts_code IN(SELECT code FROM okc_statuses_b where ste_code NOT IN('TERMINATED','EXPIRED','CANCELLED')); ---bug 12310525
4207: --AND sts_code <> 'TERMINATED';
4208: /* End changes for bug fix 6012384 (FP for 5990067) */
4209:
4210: -- BUG#3312595 mchoudha: Cursor to check for service request

Line 8204: FROM okc_statuses_b

8200: --04-JAN-2006 mchoudha for bug#4738970
8201: --Added this cursor to fetch the ste_code
8202: CURSOR cur_status (p_code in varchar2) is
8203: SELECT ste_code
8204: FROM okc_statuses_b
8205: WHERE code = p_code;
8206:
8207:
8208: --Bug#5276678