APPS.OKS_BILL_REC_PUB dependencies on OKC_STATUSES_B

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

4049: and a.opn_code = 'INVOICE'
4050: and a.allowed_yn = 'Y')
4051: OR
4052: (lines.sts_code = 'HOLD'));
4053: --And exists (Select 1 from okc_statuses_b osb,
4054: -- okc_k_headers_b hdr
4055: -- Where osb.ste_code <> 'HOLD'
4056: -- and osb.code = Hdr.sts_code ));
4057:

Line 4165: AND sts_code IN(SELECT code FROM okc_statuses_b where ste_code NOT IN('TERMINATED','EXPIRED'));

4161: FROM okc_k_lines_b
4162: WHERE cle_id = p_cle_id
4163: AND lse_id in (7,8,9,10,11,13,35,25)
4164: /* Start changes For bug fix 6012384 (FP for 5990067) */
4165: AND sts_code IN(SELECT code FROM okc_statuses_b where ste_code NOT IN('TERMINATED','EXPIRED'));
4166: --AND sts_code <> 'TERMINATED';
4167: /* End changes for bug fix 6012384 (FP for 5990067) */
4168:
4169: /* Added for BUG 3364773 */

Line 4180: AND sts_code IN(SELECT code FROM okc_statuses_b where ste_code NOT IN('TERMINATED','EXPIRED'));

4176: --AND lse_id in (1,12,14,19)
4177: /* End changes for bug fix 6012384 (FP for 5990067) */
4178: AND cle_id is null
4179: /* Start changes For bug fix 6012384 (FP for 5990067) */
4180: AND sts_code IN(SELECT code FROM okc_statuses_b where ste_code NOT IN('TERMINATED','EXPIRED'));
4181: --AND sts_code <> 'TERMINATED';
4182: /* End changes for bug fix 6012384 (FP for 5990067) */
4183:
4184: -- BUG#3312595 mchoudha: Cursor to check for service request

Line 8172: FROM okc_statuses_b

8168: --04-JAN-2006 mchoudha for bug#4738970
8169: --Added this cursor to fetch the ste_code
8170: CURSOR cur_status (p_code in varchar2) is
8171: SELECT ste_code
8172: FROM okc_statuses_b
8173: WHERE code = p_code;
8174:
8175:
8176: --Bug#5276678