DBA Data[Home] [Help]

APPS.XDPCORE_FA dependencies on XDP_FULFILL_ACTIONS

Line 4536: from XDP_FULFILL_ACTIONS XFA, XDP_FA_RUNTIME_LIST XFL

4532: is
4533:
4534: cursor c_GetLocateFEProc(FaID number) is
4535: select XFA.FE_ROUTING_PROC
4536: from XDP_FULFILL_ACTIONS XFA, XDP_FA_RUNTIME_LIST XFL
4537: where XFL.FA_INSTANCE_ID = FaID
4538: and XFA.FULFILLMENT_ACTION_ID = XFL.FULFILLMENT_ACTION_ID;
4539:
4540: l_LocateFEProc varchar2(80);

Line 5324: FROM xdp_fulfill_actions_vl fas

5320: l_display_name varchar2(100);
5321:
5322: BEGIN
5323: SELECT display_name into l_display_name
5324: FROM xdp_fulfill_actions_vl fas
5325: WHERE fas.fulfillment_action_id IN ( SELECT lst.fulfillment_action_id
5326: FROM xdp_fa_runtime_list lst
5327: WHERE fa_instance_id = p_FAInstanceID );
5328: return l_display_name;