DBA Data[Home] [Help]

APPS.AME_RULE_UTILITY_PKG dependencies on WF_ROLES

Line 288: ,wf_roles wf

284: select 'Y'
285: from ame_rules rul
286: ,ame_conditions con
287: ,ame_condition_usages cnu
288: ,wf_roles wf
289: where rul.rule_id = ruleIdIn
290: and con.condition_id = cnu.condition_id
291: and con.condition_type = ame_util.listModConditionType
292: and cnu.rule_id = rul.rule_id

Line 647: ,wf_roles wf

643: select 'Y'
644: from ame_rules rul
645: ,ame_conditions con
646: ,ame_condition_usages cnu
647: ,wf_roles wf
648: where rul.rule_id = ruleIdIn
649: and con.condition_id = cnu.condition_id
650: and cnu.rule_id = rul.rule_id
651: and con.parameter_two = wf.name

Line 1135: ,wf_roles wf

1131: --+
1132: cursor checkLMCondition(conditionIdIn in integer) is
1133: select 'Y'
1134: from ame_conditions con
1135: ,wf_roles wf
1136: where con.condition_id = conditionIdIn
1137: and con.condition_type = ame_util.listModConditionType
1138: and con.parameter_two = wf.name
1139: and wf.orig_system = 'POS'

Line 2196: from wf_roles

2192: function is_per_approver(p_name in varchar2) return boolean is
2193: --+
2194: cursor get_per_approver(p_name in varchar2) is
2195: select count(*)
2196: from wf_roles
2197: where status = 'ACTIVE'
2198: and nvl(expiration_date,sysdate) >= sysdate
2199: and orig_system = 'PER'
2200: and name = p_name;

Line 2225: from wf_roles

2221: function is_pos_approver(p_name in varchar2) return boolean is
2222: --+
2223: cursor get_pos_approver(p_name in varchar2) is
2224: select count(*)
2225: from wf_roles
2226: where status = 'ACTIVE'
2227: and nvl(expiration_date,sysdate) >= sysdate
2228: and orig_system = 'POS'
2229: and name = p_name;