APPS.XNP_UTILS dependencies on XDP_FES

Line 917: FROM xdp_fes FET

913: )
914: IS
915: CURSOR get_fe_name_for_fe_id IS
916: SELECT fulfillment_element_name
917: FROM xdp_fes FET
918: WHERE FET.fe_id = p_fe_id;
919: BEGIN
920:
921: -- get the fe name

Line 956: FROM xdp_fes FET,

952: in differenc procedures.. skilaru 03/26/2001
953:
954: CURSOR get_fe_name_for_sp IS
955: SELECT fulfillment_element_name
956: FROM xdp_fes FET,
957: xnp_sp_adapters SPA,
958: xdp_fe_generic_config SWG
959: WHERE FET.fe_id = SPA.fe_id
960: AND SPA.fe_id = SWG.fe_id

Line 1011: FROM xdp_fes FET,

1007: several procedures. -- skilaru 03/25/2001
1008:
1009: CURSOR get_fe_name_for_sp IS
1010: SELECT fulfillment_element_name
1011: FROM xdp_fes FET,
1012: xnp_sp_adapters SPA,
1013: xdp_fe_generic_config SWG
1014: WHERE FET.fe_id = SPA.fe_id
1015: AND SPA.fe_id = SWG.fe_id

Line 1596: FROM xdp_fes FET,

1592:
1593: IS
1594: CURSOR get_fe_name_for_sp1 IS
1595: SELECT fulfillment_element_name, FET.fe_id
1596: FROM xdp_fes FET,
1597: xnp_sp_adapters SPA,
1598: xdp_fe_generic_config SWG
1599: WHERE FET.fe_id = SPA.fe_id
1600: AND SPA.fe_id = SWG.fe_id

Line 1660: FROM xdp_adapter_reg xad, xdp_adapter_types_b t,xdp_fes XFE

1656: l_adapter_name varchar2(80) := NULL;
1657:
1658: cursor c_getadapter IS
1659: SELECT xad.adapter_name
1660: FROM xdp_adapter_reg xad, xdp_adapter_types_b t,xdp_fes XFE
1661: WHERE XAD.fe_id = XFE.fe_id
1662: AND XFE.fulfillment_element_name = p_fe_name
1663: AND xad.adapter_type = t.adapter_type
1664: AND application_mode='QUEUE'