APPS.OKS_WF_K_PROCESS_PVT dependencies on OKC_STATUSES_B

Line 2811: OKC_STATUSES_B sts

2807:
2808: CURSOR c_old_sts (p_contract_id IN NUMBER) is
2809: SELECT STS_CODE
2810: FROM OKC_K_HEADERS_ALL_B okck,
2811: OKC_STATUSES_B sts
2812: WHERE sts.ste_code = 'ENTERED'
2813: AND id = p_contract_id
2814: AND sts.code = okck.sts_code;
2815:

Line 2817: SELECT CODE FROM okc_statuses_b

2813: AND id = p_contract_id
2814: AND sts.code = okck.sts_code;
2815:
2816: CURSOR l_new_sts_code_csr IS
2817: SELECT CODE FROM okc_statuses_b
2818: WHERE ste_code = 'CANCELLED'
2819: AND default_yn = 'Y'
2820: AND sysdate BETWEEN START_DATE AND NVL(end_date,SYSDATE+1);
2821:

Line 2848: l_old_sts OKC_STATUSES_B.CODE%TYPE;

2844: l_send_email_yn VARCHAR2(1) := 'N';
2845: l_item_key wf_items.item_key%TYPE;
2846: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
2847: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
2848: l_old_sts OKC_STATUSES_B.CODE%TYPE;
2849: l_new_sts OKC_STATUSES_B.CODE%TYPE;
2850: l_rownotfound BOOLEAN := FALSE;
2851: l_reason VARCHAR2(250);
2852:

Line 2849: l_new_sts OKC_STATUSES_B.CODE%TYPE;

2845: l_item_key wf_items.item_key%TYPE;
2846: l_email_attr_rec OKS_WF_K_PROCESS_PVT.email_attr_rec;
2847: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
2848: l_old_sts OKC_STATUSES_B.CODE%TYPE;
2849: l_new_sts OKC_STATUSES_B.CODE%TYPE;
2850: l_rownotfound BOOLEAN := FALSE;
2851: l_reason VARCHAR2(250);
2852:
2853: BEGIN

Line 8858: OKC_STATUSES_B sts

8854: nvl(okck.CONTRACT_NUMBER_MODIFIER, FND_API.G_MISS_CHAR) CONTRACT_NUMBER_MODIFIER,
8855: nvl(oksk.RENEWAL_STATUS, G_NEG_STS_DRAFT) RENEWAL_STATUS
8856: FROM OKS_K_HEADERS_B oksk,
8857: OKC_K_HEADERS_ALL_B okck,
8858: OKC_STATUSES_B sts
8859: WHERE oksk.chr_id = okck.id
8860: AND sts.ste_code = 'ENTERED'
8861: AND sts.code = okck.sts_code
8862: AND okck.template_yn = 'N'