DBA Data[Home] [Help]

APPS.OKS_K_ACTIONS_PVT dependencies on OKC_STATUSES_B

Line 680: okc_statuses_b sts

676:
677: CURSOR reminder_cur IS
678: SELECT 'X'
679: FROM okc_k_headers_all_b okck,
680: okc_statuses_b sts
681: WHERE okck.sts_code = sts.code
682: AND sts.ste_code = 'ENTERED'
683: AND okck.id = p_chr_id;
684:

Line 690: okc_statuses_b sts

686:
687: CURSOR chr_cur IS
688: SELECT 'X'
689: FROM okc_k_headers_all_b okck,
690: okc_statuses_b sts
691: WHERE okck.sts_code = sts.code
692: AND sts.ste_code = 'ENTERED'
693: AND okck.id = p_chr_id
694: AND NOT EXISTS