APPS.FTE_ACS_PKG dependencies on FTE_SEL_SEARCH_ENTITIES_TMP

Line 266: FROM FTE_SEL_SEARCH_ENTITIES_TMP

262: initial_pickup_loc_id,
263: ultimate_dropoff_loc_id,
264: initial_pickup_date,
265: ultimate_dropoff_date
266: FROM FTE_SEL_SEARCH_ENTITIES_TMP
267: WHERE rule_id IS NULL;
268:
269:
270: l_failed_entity_tab FTE_CS_TEMP_ENTITY_TAB;

Line 500: FROM FTE_SEL_SEARCH_ENTITIES_TMP

496: initial_pickup_loc_id,
497: ultimate_dropoff_loc_id,
498: initial_pickup_date,
499: ultimate_dropoff_date
500: FROM FTE_SEL_SEARCH_ENTITIES_TMP
501: WHERE rule_id IS NOT NULL;
502:
503: CURSOR c_get_transit_time_for_rule(p_rule_id IN NUMBER) IS
504: SELECT attribute_value_from_number,

Line 1076: UPDATE FTE_SEL_SEARCH_ENTITIES_TMP

1072: IF NOT(l_single_entity) THEN
1073:
1074: IF (p_entity = 'TRIP') THEN
1075: FORALL j in l_first .. l_last
1076: UPDATE FTE_SEL_SEARCH_ENTITIES_TMP
1077: SET rule_id = l_entity_rule_rec.rule_id_tab(j)
1078: WHERE trip_id = l_entity_rule_rec.entity_id_tab(j);
1079:
1080: ELSIF (p_entity IN ('DLVY','PSEUDO_DLVY')) THEN

Line 1082: UPDATE FTE_SEL_SEARCH_ENTITIES_TMP

1078: WHERE trip_id = l_entity_rule_rec.entity_id_tab(j);
1079:
1080: ELSIF (p_entity IN ('DLVY','PSEUDO_DLVY')) THEN
1081: FORALL j in l_first .. l_last
1082: UPDATE FTE_SEL_SEARCH_ENTITIES_TMP
1083: SET rule_id = l_entity_rule_rec.rule_id_tab(j)
1084: WHERE delivery_id = l_entity_rule_rec.entity_id_tab(j);
1085: END IF;
1086: END IF;