APPS.MTL_PARAMETERS_PKG dependencies on WMS_SELECTION_CRITERIA_TXN

Line 1981: FROM wms_selection_criteria_txn

1977: SELECT 'Y'
1978: INTO strgy_assn_exist
1979: FROM DUAL
1980: WHERE EXISTS(SELECT from_organization_id
1981: FROM wms_selection_criteria_txn
1982: WHERE from_organization_id = p_organization_id
1983: AND return_type_code = 'S'
1984: AND return_type_id = 8
1985: AND rule_type_code = 2);

Line 1995: SELECT wms_selection_criteria_txn_s.NEXTVAL

1991: IF strgy_assn_exist = 'Y' THEN
1992: RETURN;
1993: END IF;
1994:
1995: SELECT wms_selection_criteria_txn_s.NEXTVAL
1996: INTO l_stg_assignment_id
1997: FROM DUAL;
1998:
1999: wms_strategy_upgrade_pvt.insert_row(