APPS.ASN_MIG_SALES_TEAM_PVT dependencies on AS_LEAD_LINES_LOG

Line 53: FROM as_lead_lines_log

49: l_update_count NUMBER;
50:
51: CURSOR c_lead_line_logs(p_lead_id NUMBER) IS
52: SELECT log_id, lead_line_id, last_update_date
53: FROM as_lead_lines_log
54: WHERE lead_id = p_lead_id
55: ORDER BY lead_line_id ASC, last_update_date DESC, log_id DESC;
56:
57: CURSOR c_sales_credits_logs(p_lead_id NUMBER) IS

Line 102: UPDATE as_lead_lines_log -- @@

98: l_prev_last_update_date := l_last_update_date;
99: END LOOP;
100:
101: FORALL i IN l_log_ids.FIRST..l_log_ids.LAST
102: UPDATE as_lead_lines_log -- @@
103: SET endday_log_flag = l_endday_log_flags(i)
104: WHERE log_id = l_log_ids(i) AND endday_log_flag IS NULL;
105:
106: l_update_count := SQL%ROWCOUNT;

Line 1520: FROM as_lead_lines_log

1516: FROM as_leads_all;
1517:
1518: CURSOR c_lead_line_logs(p_lead_id NUMBER) IS
1519: SELECT log_id, lead_line_id, last_update_date
1520: FROM as_lead_lines_log
1521: WHERE lead_id = p_lead_id
1522: ORDER BY lead_line_id ASC, last_update_date DESC, log_id DESC;
1523:
1524: CURSOR c_sales_credits_logs(p_lead_id NUMBER) IS

Line 1592: UPDATE as_lead_lines_log -- @@

1588: l_endday_log_flags(i) := l_endday_log_flag;
1589: l_prev_last_update_date := l_last_update_date;
1590: END LOOP;
1591: FORALL i IN l_log_ids.FIRST..l_log_ids.LAST
1592: UPDATE as_lead_lines_log -- @@
1593: SET endday_log_flag = l_endday_log_flags(i)
1594: WHERE log_id = l_log_ids(i) AND endday_log_flag IS NULL;
1595:
1596: l_update_count := SQL%ROWCOUNT;