APPS.OKS_WF_K_PROCESS_PVT dependencies on OKC_STATUSES_B

Line 2755: OKC_STATUSES_B sts

2751:
2752: CURSOR c_old_sts (p_contract_id IN NUMBER) is
2753: SELECT STS_CODE
2754: FROM OKC_K_HEADERS_ALL_B okck,
2755: OKC_STATUSES_B sts
2756: WHERE sts.ste_code = 'ENTERED'
2757: AND id = p_contract_id
2758: AND sts.code = okck.sts_code;
2759:

Line 2761: SELECT CODE FROM okc_statuses_b

2757: AND id = p_contract_id
2758: AND sts.code = okck.sts_code;
2759:
2760: CURSOR l_new_sts_code_csr IS
2761: SELECT CODE FROM okc_statuses_b
2762: WHERE ste_code = 'CANCELLED'
2763: AND default_yn = 'Y'
2764: AND sysdate BETWEEN START_DATE AND NVL(end_date,SYSDATE+1);
2765:

Line 2770: l_old_sts OKC_STATUSES_B.CODE%TYPE;

2766: l_send_email_yn VARCHAR2(1) := 'N';
2767: l_item_key wf_items.item_key%TYPE;
2768: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
2769: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
2770: l_old_sts OKC_STATUSES_B.CODE%TYPE;
2771: l_new_sts OKC_STATUSES_B.CODE%TYPE;
2772: l_rownotfound BOOLEAN := FALSE;
2773: l_reason VARCHAR2(250);
2774:

Line 2771: l_new_sts OKC_STATUSES_B.CODE%TYPE;

2767: l_item_key wf_items.item_key%TYPE;
2768: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
2769: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
2770: l_old_sts OKC_STATUSES_B.CODE%TYPE;
2771: l_new_sts OKC_STATUSES_B.CODE%TYPE;
2772: l_rownotfound BOOLEAN := FALSE;
2773: l_reason VARCHAR2(250);
2774:
2775: BEGIN

Line 8554: OKC_STATUSES_B sts

8550: nvl(okck.CONTRACT_NUMBER_MODIFIER, FND_API.G_MISS_CHAR) CONTRACT_NUMBER_MODIFIER,
8551: nvl(oksk.RENEWAL_STATUS, G_NEG_STS_DRAFT) RENEWAL_STATUS
8552: FROM OKS_K_HEADERS_B oksk,
8553: OKC_K_HEADERS_ALL_B okck,
8554: OKC_STATUSES_B sts
8555: WHERE oksk.chr_id = okck.id
8556: AND sts.ste_code = 'ENTERED'
8557: AND sts.code = okck.sts_code
8558: AND okck.template_yn = 'N'