APPS.FA_INS_ADJUST_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 643: FROM FA_DISTRIBUTION_HISTORY

639: CURSOR C1 IS
640: SELECT DISTRIBUTION_ID,
641: CODE_COMBINATION_ID,
642: UNITS_ASSIGNED
643: FROM FA_DISTRIBUTION_HISTORY
644: WHERE ASSET_ID = h_asset_id
645: AND BOOK_TYPE_CODE = h_dist_book
646: AND (
647: (adj_ptr.selection_mode <> FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE_PARTIAL

Line 753: FROM FA_DISTRIBUTION_HISTORY

749: if (adj_ptr.selection_mode <> FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE_PARTIAL) then
750:
751: SELECT COUNT(*)
752: INTO h_distribution_lines
753: FROM FA_DISTRIBUTION_HISTORY
754: WHERE ASSET_ID=h_asset_id
755: AND book_type_code=h_dist_book
756: AND DATE_INEFFECTIVE IS NULL;
757:

Line 763: FROM FA_DISTRIBUTION_HISTORY

759:
760: -- the number of the newly created rows only
761: SELECT COUNT(*)
762: INTO h_distribution_lines
763: FROM FA_DISTRIBUTION_HISTORY
764: WHERE ASSET_ID=h_asset_id
765: AND book_type_code=h_dist_book
766: AND transaction_header_id_in=adj_ptr.selection_thid;
767:

Line 991: FROM FA_DISTRIBUTION_HISTORY

987: SELECT distribution_id,
988: code_combination_id,
989: units_assigned,
990: transaction_header_id_in
991: FROM FA_DISTRIBUTION_HISTORY
992: WHERE asset_id = h_asset_id
993: AND book_type_code=h_dist_book
994: AND (
995: (adj_ptr.selection_mode <> FA_ADJUST_TYPE_PKG.FA_AJ_CLEAR_PARTIAL

Line 1402: FROM FA_DISTRIBUTION_HISTORY

1398: CURSOR C1 IS
1399: SELECT DISTRIBUTION_ID,
1400: CODE_COMBINATION_ID,
1401: TRANSACTION_UNITS
1402: FROM FA_DISTRIBUTION_HISTORY
1403: WHERE ASSET_ID = h_asset_id
1404: AND BOOK_TYPE_CODE = h_dist_book
1405: AND RETIREMENT_ID = h_ret_id
1406: ORDER BY DISTRIBUTION_ID;

Line 1461: FROM FA_DISTRIBUTION_HISTORY

1457: h_dist_book := FA_CACHE_PKG.fazcbc_record.distribution_source_book;
1458: h_mesg_name:='FA_INS_ADJ_CNT_ACTIVE';
1459: SELECT COUNT(*)
1460: INTO h_distribution_lines
1461: FROM FA_DISTRIBUTION_HISTORY
1462: WHERE ASSET_ID = h_asset_id
1463: AND book_type_code = h_dist_book
1464: AND RETIREMENT_ID = h_ret_id;
1465: