APPS.EDR_PSIG_RULE dependencies on WF_EVENT_SUBSCRIPTIONS

Line 1843: from wf_events a, wf_event_subscriptions b

1839: -- present for the parent event
1840: --
1841:
1842: select count(*) INTO l_no_enabled_eres_sub
1843: from wf_events a, wf_event_subscriptions b
1844: where a.GUID = b.EVENT_FILTER_GUID
1845: and a.name = l_parent_event
1846: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
1847: --Bug No 4912782- Start

Line 1861: from wf_events a, wf_event_subscriptions b

1857: -- for parent event. if more than one ERES subscription is ENABLED
1858: -- Raise Multiple ERES Subscriptions error
1859: --
1860: select count(*) INTO l_no_enabled_eres_sub
1861: from wf_events a, wf_event_subscriptions b
1862: where a.GUID = b.EVENT_FILTER_GUID
1863: and a.name = l_parent_event
1864: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
1865: and b.STATUS = 'ENABLED'

Line 1918: from wf_events a, wf_event_subscriptions b

1914: -- for current event. if more than one ERES subscription is ENABLED
1915: -- Raise Multiple ERES Subscriptions error
1916: --
1917: select count(*) INTO l_no_enabled_eres_sub
1918: from wf_events a, wf_event_subscriptions b
1919: where a.GUID = b.EVENT_FILTER_GUID
1920: and a.name = p_event.event_name
1921: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
1922: and b.STATUS = 'ENABLED'

Line 2858: from wf_event_subscriptions

2854: P_EVENT.SETCORRELATIONID(l_edr_event_id);
2855: /* Select the workflow process for the subscription */
2856: select wf_process_type,wf_process_name
2857: into l_wftype, l_wfprocess
2858: from wf_event_subscriptions
2859: where guid = p_subscription_guid;
2860:
2861: wf_event.AddParameterToList('#WF_PAGEFLOW_ITEMTYPE', l_wftype,p_event.Parameter_List); /* Page Flow Workflow type*/
2862: wf_event.AddParameterToList('#WF_PAGEFLOW_ITEMPROCESS', l_wfprocess,p_event.Parameter_List); /* Page Flow Workflow process*/