APPS.FA_PROCESS_IMPAIRMENT_PKG dependencies on FA_MC_ITF_IMPAIRMENTS

Line 911: FROM FA_MC_ITF_IMPAIRMENTS

907: WHERE REQUEST_ID = l_request_id
908: AND SET_OF_BOOKS_ID = l_set_of_books_id
909: AND IMPAIRMENT_ID IN
910: (SELECT IMPAIRMENT_ID
911: FROM FA_MC_ITF_IMPAIRMENTS
912: WHERE PERIOD_OF_ADDITION_FLAG = 'F'
913: AND REQUEST_ID = l_request_id
914: AND SET_OF_BOOKS_ID = l_set_of_books_id);
915: --Bug# 7045739 end

Line 1304: delete from fa_mc_itf_impairments itmp

1300: --
1301: -- Primary Book
1302: --
1303: --Bug# 7292608 When updating uploaded impairment,existing row needs to be deleted first
1304: delete from fa_mc_itf_impairments itmp
1305: where set_of_books_id = p_set_of_books_id
1306: and exists
1307: (select 'Uploaded impairment'
1308: from fa_mc_books bk , fa_mc_impairments imp

Line 1324: insert into fa_mc_itf_impairments(

1320: and bk.transaction_header_id_out is null
1321: and itmp.impairment_id = imp.impairment_id);
1322: --Bug6433799
1323: --Added the Set_of_books_id
1324: insert into fa_mc_itf_impairments(
1325: SET_OF_BOOKS_ID
1326: , REQUEST_ID
1327: , IMPAIRMENT_ID
1328: , BOOK_TYPE_CODE

Line 1428: delete from fa_mc_itf_impairments itmp

1424:
1425: commit;
1426:
1427: --Bug# 7292608 When updating uploaded impairment,existing row needs to be deleted first
1428: delete from fa_mc_itf_impairments itmp
1429: where set_of_books_id = p_set_of_books_id
1430: and exists
1431: (select 'Uploaded impairment'
1432: from fa_mc_books bk , fa_mc_impairments imp

Line 1447: insert into fa_mc_itf_impairments(

1443: and bk.transaction_header_id_out is null
1444: and itmp.impairment_id = imp.impairment_id);
1445:
1446: -- Insert goodwill asset record into itf table
1447: insert into fa_mc_itf_impairments(
1448: SET_OF_BOOKS_ID
1449: , REQUEST_ID
1450: , IMPAIRMENT_ID
1451: , BOOK_TYPE_CODE