DBA Data[Home] [Help]

APPS.AMS_APPROVAL_PVT dependencies on WF_ROUTING_RULES

Line 947: FROM wf_routing_rules a, wf_routing_rule_attributes b, wf_routing_rule_attributes c

943: IS
944:
945: CURSOR c_get_rule IS
946: SELECT b.text_value, b.number_value
947: FROM wf_routing_rules a, wf_routing_rule_attributes b, wf_routing_rule_attributes c
948: WHERE a.rule_id = b.rule_id
949: AND a.role = p_approver_name
950: AND TRUNC(sysdate) BETWEEN TRUNC(NVL(begin_date, sysdate -1)) AND
951: TRUNC(NVL(end_date,sysdate+1))