APPS.OKS_WF_K_APPROVE dependencies on WF_ROUTING_RULES

Line 690: FROM wf_routing_rules

686:
687: /*Added for bug 8558419*/
688: CURSOR csr_vacation_rule(p_name IN VARCHAR2) IS
689: SELECT action
690: FROM wf_routing_rules
691: WHERE message_name ='SIGN_CONTRACT'
692: AND role =p_name
693: AND message_type='OKCAUKAP'
694: AND ((SYSDATE >= begin_date) AND (SYSDATE <= Nvl(end_date,SYSDATE)));

Line 699: FROM wf_routing_rules

695:
696:
697: CURSOR csr_vr_approval(p_name IN VARCHAR2) IS
698: SELECT action
699: FROM wf_routing_rules
700: WHERE message_name ='APPROVE_CONTRACT'
701: AND role =p_name
702: AND message_type='OKCAUKAP'
703: AND ((SYSDATE >= begin_date) AND (SYSDATE <= Nvl(end_date,SYSDATE)));