DBA Data[Home] [Help]

APPS.OZF_FUND_APPROVAL_PVT dependencies on WF_ROUTING_RULE_ATTRIBUTES

Line 1447: FROM wf_routing_rules a, wf_routing_rule_attributes b

1443: x_number_value OUT NOCOPY NUMBER)
1444: IS
1445: CURSOR c_get_rule IS
1446: SELECT b.text_value, b.number_value
1447: FROM wf_routing_rules a, wf_routing_rule_attributes b
1448: WHERE a.rule_id = b.rule_id
1449: AND a.role = p_approver_name
1450: AND TRUNC(sysdate) BETWEEN TRUNC(NVL(begin_date, sysdate -1)) AND
1451: TRUNC(NVL(end_date,sysdate+1))