DBA Data[Home] [Help]

APPS.CSP_PLAN_DETAILS_PKG dependencies on CSP_USAGE_HISTORIES

Line 1177: from csp_usage_histories cuh,

1173: sysdate,
1174: fnd_global.user_id,
1175: sysdate,
1176: fnd_global.login_id
1177: from csp_usage_histories cuh,
1178: csp_forecast_rules_b cfrb
1179: where history_data_type = 2
1180: and period_start_date between decode(l_forecast_method,4,trunc(sysdate) + (l_counter - 1) * l_period_size,period_start_date)
1181: and decode(l_forecast_method,4,trunc(sysdate) + (l_counter - 1) * l_period_size + (l_period_size - 1),trunc(sysdate) + l_period_size * l_forecast_periods - 1)

Line 1223: from csp_usage_histories cuh

1219: sysdate,
1220: fnd_global.user_id,
1221: sysdate,
1222: fnd_global.login_id
1223: from csp_usage_histories cuh
1224: where history_data_type in (7,8)
1225: and period_start_date between trunc(sysdate) + (l_counter - 1) * l_period_size
1226: and trunc(sysdate) + l_counter * l_period_size - 1
1227: and organization_id = l_organization_id