APPS.FII_AP_INV_DISTRIBUTIONS_B_C dependencies on FII_CHANGE_LOG

Line 187: FROM fii_change_log

183: end if;
184:
185: SELECT DECODE(item_value, 'Y', 'TRUE', 'FALSE')
186: INTO l_result
187: FROM fii_change_log
188: WHERE log_item = 'AP_RESUMMARIZE';
189:
190: IF l_result = 'TRUE' THEN
191:

Line 211: UPDATE fii_change_log

207: WHEN NO_DATA_FOUND THEN l_count2 := 0;
208: END;
209:
210: IF (l_count1 = 0 AND l_count2 = 0) then
211: UPDATE fii_change_log
212: SET item_value = 'N',
213: last_update_date = SYSDATE,
214: last_update_login = g_fii_login_id,
215: last_updated_by = g_fii_user_id

Line 1602: UPDATE fii_change_log

1598: -- is not necessary since everything is
1599: -- going to be freshly loaded
1600: ---------------------------------------------
1601: g_state := 'Updating change log';
1602: UPDATE fii_change_log
1603: SET item_value = 'N',
1604: last_update_date = SYSDATE,
1605: last_update_login = g_fii_login_id,
1606: last_updated_by = g_fii_user_id