DBA Data[Home] [Help]

APPS.ASN_MIG_SALES_CREDITS_PVT dependencies on AS_LEAD_LINES_ALL

Line 1462: FROM AS_LEAD_LINES_ALL

1458: WHERE lead_id = c_lead_id;
1459:
1460: CURSOR c_lines(c_lead_id NUMBER,c_lead_line_id NUMBER) IS
1461: SELECT *
1462: FROM AS_LEAD_LINES_ALL
1463: WHERE lead_id = c_lead_id
1464: AND lead_line_id = c_lead_line_id;
1465:
1466: CURSOR c_sales_credits(c_lead_id NUMBER, c_lead_line_id NUMBER , c_salesforce_id NUMBER ,c_salesgroup_id NUMBER ) IS

Line 2410: update as_lead_lines_all

2406: end if;
2407: END LOOP;
2408:
2409: FORALL I IN l_lead_id.first..l_lead_id.last
2410: update as_lead_lines_all
2411: set forecast_date = NULL, rolling_forecast_flag = 'N' ,
2412: last_updated_by = FND_GLOBAL.user_id,
2413: last_update_date = sysdate,
2414: last_update_login = FND_GLOBAL.conc_login_id