APPS.ASN_MIG_SALES_TEAM_PVT dependencies on AS_SALES_CREDITS_LOG

Line 59: FROM as_sales_credits_log

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
58: SELECT log_id, sales_credit_id, last_update_date
59: FROM as_sales_credits_log
60: WHERE lead_id = p_lead_id
61: ORDER BY sales_credit_id ASC, last_update_date DESC, log_id DESC;
62:
63: BEGIN

Line 147: UPDATE as_sales_credits_log -- @@

143: l_prev_last_update_date := l_last_update_date;
144: END LOOP;
145:
146: FORALL i IN l_log_ids.FIRST..l_log_ids.LAST
147: UPDATE as_sales_credits_log -- @@
148: SET endday_log_flag = l_endday_log_flags(i)
149: WHERE log_id = l_log_ids(i) AND endday_log_flag IS NULL;
150:
151: l_update_count := SQL%ROWCOUNT;

Line 1526: FROM as_sales_credits_log

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
1525: SELECT log_id, sales_credit_id, last_update_date
1526: FROM as_sales_credits_log
1527: WHERE lead_id = p_lead_id
1528: ORDER BY sales_credit_id ASC, last_update_date DESC, log_id DESC;
1529:
1530: TYPE num_list is TABLE of NUMBER INDEX BY BINARY_INTEGER;

Line 1636: UPDATE as_sales_credits_log -- @@

1632: l_prev_last_update_date := l_last_update_date;
1633: END LOOP;
1634:
1635: FORALL i IN l_log_ids.FIRST..l_log_ids.LAST
1636: UPDATE as_sales_credits_log -- @@
1637: SET endday_log_flag = l_endday_log_flags(i)
1638: WHERE log_id = l_log_ids(i) AND endday_log_flag IS NULL;
1639:
1640: l_update_count := SQL%ROWCOUNT;