DBA Data[Home] [Help]

APPS.WMS_STRATEGY_PVT dependencies on WMS_DATECHECK_PVT

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

530: WHERE wsm.strategy_id = p_strategy_id
531: AND wsb.strategy_id = p_strategy_id
532: AND wrb.rule_id = wsm.rule_id
533: AND wrb.enabled_flag = 'Y'
534: AND wms_datecheck_pvt.date_valid (wsb.organization_id,
535: wsm.date_type_code,
536: wsm.date_type_from,
537: wsm.date_type_to,
538: wsm.effective_from,

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

1275: ';
1276:
1277: -- add effective date restrictions
1278: l_where := l_where
1279: ||'and wms_datecheck_pvt.date_valid( '
1280: ||l_table_alias||'.organization_id, '
1281: ||l_table_alias||'.date_type_code, '
1282: ||l_table_alias||'.date_type_from, '
1283: ||l_table_alias||'.date_type_to, '