APPS.OKC_RENEW_PVT dependencies on OKC_STATUSES_B

Line 91: okc_statuses_b sts

87: ) is
88: CURSOR cur_auto_renew is
89: SELECT k.id,k.contract_number,k.contract_number_modifier,k.start_date,k.END_date,k.object_version_number
90: FROM okc_k_headers_b k,
91: okc_statuses_b sts
92: WHERE k.date_renewed is null
93: and k.sts_code = sts.code
94: and sts.ste_code in ('ACTIVE','EXPIRED','SIGNED')
95: and k.date_terminated is null

Line 756: FROM okc_k_lines_b l, okc_statuses_b sts

752: FUNCTION VALIDATE_LINE(p_contract_id IN NUMBER) RETURN VARCHAR2
753: IS
754: CURSOR cur_k_lines is
755: SELECT ID
756: FROM okc_k_lines_b l, okc_statuses_b sts
757: WHERE sts.code = l.sts_code
758: and sts.ste_code in ('ACTIVE','EXPIRED','SIGNED')
759: and l.dnz_chr_id = p_contract_id
760: and l.date_renewed is null

Line 3692: FROM okc_k_headers_b k,okc_statuses_b s

3688: be displayed. */
3689:
3690: Cursor cur_ren(p_chr_id number) is
3691: SELECT CONTRACT_NUMBER,CONTRACT_NUMBER_MODIFIER,ste_code
3692: FROM okc_k_headers_b k,okc_statuses_b s
3693: where k.id=p_chr_id and k.sts_code=s.code;
3694:
3695: k_ren_rec cur_ren%rowtype;
3696: l_id number:=OKC_API.G_MISS_NUM;