APPS.OKS_AUTH_UTIL_PUB dependencies on OKC_CONDITION_HEADERS_B

Line 486: FROM okc_condition_headers_b

482: p_template_counter_group_id NUMBER DEFAULT NULL) RETURN NUMBER
483: IS
484: CURSOR get_inst_event_csr IS
485: SELECT COUNT(object_id) cnt
486: FROM okc_condition_headers_b
487: WHERE object_id = p_cle_id
488: AND jtot_object_code = 'OKC_K_LINE';
489:
490: get_inst_event_rec get_inst_event_csr%ROWTYPE;

Line 501: FROM okc_condition_headers_b

497: get_ctr_association_rec get_ctr_association_csr%ROWTYPE;
498:
499: CURSOR get_template_event_csr (p_ctr_grp_id NUMBER) IS
500: SELECT COUNT(counter_group_id) cnt
501: FROM okc_condition_headers_b
502: WHERE counter_group_id = p_ctr_grp_id
503: AND template_yn = 'Y';
504:
505: get_template_event_rec get_template_event_csr%ROWTYPE;

Line 517: FROM OKC_CONDITION_HEADERS_B

513:
514: FUNCTION chk_event_template (p_ctr_grp_id NUMBER) RETURN NUMBER IS
515: CURSOR get_event_csr (p_ctr_grp_id NUMBER) IS
516: SELECT template_yn
517: FROM OKC_CONDITION_HEADERS_B
518: WHERE counter_group_id = p_ctr_grp_id;
519: get_event_rec get_event_csr%ROWTYPE;
520: l_return_no NUMBER := 0;
521: BEGIN