DBA Data[Home] [Help]

APPS.WF_NTF_RULE dependencies on WF_NTF_RULE_CRITERIA

Line 25: wf_ntf_rule_criteria wnrc

21:
22: cursor c_rules is
23: select distinct wnrc.message_type
24: from wf_ntf_rules wnr,
25: wf_ntf_rule_criteria wnrc
26: where wnr.rule_name = l_rule_name
27: and wnr.rule_name = wnrc.rule_name;
28: begin
29: org_user_id := fnd_global.user_id;

Line 77: wf_ntf_rule_criteria wnrc,

73: wnrm.attribute_name,
74: wnr.customization_level,
75: wnr.rule_name
76: from wf_ntf_rules wnr,
77: wf_ntf_rule_criteria wnrc,
78: wf_ntf_rule_maps wnrm
79: where wnr.rule_name = wnrc.rule_name
80: and wnr.rule_name = wnrm.rule_name
81: and wnr.status = 'ENABLED'