APPS.EDR_ISIGN_CHECKLIST_PVT dependencies on WF_EVENTS

Line 53: wf_events a, wf_event_subscriptions b

49: l_temp_template_ver varchar2(200);
50: CURSOR GET_EVT_SUBSCRIPTION_DETAILS IS
51: select b.guid,A.status,b.status
52: from
53: wf_events a, wf_event_subscriptions b
54: where a.GUID = b.EVENT_FILTER_GUID
55: and a.name = p_event_name
56: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
57: and b.STATUS = 'ENABLED'

Line 78: wf_events a, wf_event_subscriptions b

74: -- Verify is more than one active ERES subscriptions are present
75: --
76: select count(*) INTO l_no_enabled_eres_sub
77: from
78: wf_events a, wf_event_subscriptions b
79: where a.GUID = b.EVENT_FILTER_GUID
80: and a.name = p_event_name
81: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
82: and b.STATUS = 'ENABLED'

Line 118: WHERE APPLICATION_SHORT_NAME in (SELECT OWNER_TAG from WF_EVENTS

114: is OWNER_TAG will always be set to application Short Name*/
115:
116: SELECT application_id,APPLICATION_SHORT_NAME into l_application_id,l_application_code
117: FROM FND_APPLICATION
118: WHERE APPLICATION_SHORT_NAME in (SELECT OWNER_TAG from WF_EVENTS
119: WHERE NAME=evt.getEventName( ));
120:
121: /* AME Enhancement Code. Determine if singature is need or not and also get approvers */
122: