DBA Data[Home] [Help]

APPS.WMS_STRATEGY_PVT dependencies on WMS_DATECHECK_PVT

Line 522: AND wms_datecheck_pvt.date_valid (wsb.organization_id,

518: WHERE wsm.strategy_id = p_strategy_id
519: AND wsb.strategy_id = p_strategy_id
520: AND wrb.rule_id = wsm.rule_id
521: AND wrb.enabled_flag = 'Y'
522: AND wms_datecheck_pvt.date_valid (wsb.organization_id,
523: wsm.date_type_code,
524: wsm.date_type_from,
525: wsm.date_type_to,
526: wsm.effective_from,

Line 1241: ||'and wms_datecheck_pvt.date_valid( '

1237: ';
1238:
1239: -- add effective date restrictions
1240: l_where := l_where
1241: ||'and wms_datecheck_pvt.date_valid( '
1242: ||l_table_alias||'.organization_id, '
1243: ||l_table_alias||'.date_type_code, '
1244: ||l_table_alias||'.date_type_from, '
1245: ||l_table_alias||'.date_type_to, '