DBA Data[Home] [Help]

APPS.OKS_K_ACTIONS_PVT dependencies on OKC_STATUSES_B

Line 651: okc_statuses_b sts

647:
648: CURSOR reminder_cur IS
649: SELECT 'X'
650: FROM okc_k_headers_all_b okck,
651: okc_statuses_b sts
652: WHERE okck.sts_code = sts.code
653: AND sts.ste_code = 'ENTERED'
654: AND okck.id = p_chr_id;
655:

Line 661: okc_statuses_b sts

657:
658: CURSOR chr_cur IS
659: SELECT 'X'
660: FROM okc_k_headers_all_b okck,
661: okc_statuses_b sts
662: WHERE okck.sts_code = sts.code
663: AND sts.ste_code = 'ENTERED'
664: AND okck.id = p_chr_id
665: AND NOT EXISTS