APPS.FA_UTIL_PVT dependencies on FA_ASSET_HISTORY

Line 978: p_date_effective IN FA_ASSET_HISTORY.date_effective%TYPE DEFAULT NULL,

974:
975: FUNCTION get_asset_cat_rec
976: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
977: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
978: p_date_effective IN FA_ASSET_HISTORY.date_effective%TYPE DEFAULT NULL,
979: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
980:
981: l_asset_category_id FA_ADDITIONS.asset_category_id%TYPE;
982:

Line 1054: fa_asset_history ah

1050: px_asset_cat_rec.desc_flex.attribute30,
1051: px_asset_cat_rec.desc_flex.attribute_category_code,
1052: px_asset_cat_rec.desc_flex.context
1053: from fa_additions_b ad,
1054: fa_asset_history ah
1055: where ad.asset_id = p_asset_hdr_rec.asset_id
1056: and ad.asset_id = ah.asset_id
1057: and ((p_date_effective is null and
1058: ah.date_ineffective is null) or

Line 1086: p_date_effective IN FA_ASSET_HISTORY.date_effective%TYPE DEFAULT NULL,

1082:
1083: FUNCTION get_asset_type_rec
1084: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1085: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
1086: p_date_effective IN FA_ASSET_HISTORY.date_effective%TYPE DEFAULT NULL,
1087: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
1088:
1089: BEGIN
1090:

Line 1094: fa_asset_history ah

1090:
1091: select ah.asset_type
1092: into px_asset_type_rec.asset_type
1093: from fa_additions_b ad,
1094: fa_asset_history ah
1095: where ad.asset_id = p_asset_hdr_rec.asset_id
1096: and ad.asset_id = ah.asset_id
1097: and (ah.date_effective = nvl(p_date_effective, to_date('01/01/0001', 'DD/MM/YYYY')) or
1098: ah.date_ineffective is null);

Line 1833: from fa_asset_history

1829: BEGIN
1830:
1831: select units
1832: into x_current_units
1833: from fa_asset_history
1834: where asset_id = p_asset_id
1835: and date_ineffective is null;
1836:
1837: return TRUE;

Line 1849: value2 => 'FA_ASSET_HISTORY'

1845: name => 'FA_SHARED_ACTION_TABLE',
1846: token1 => 'ACTION',
1847: value1 => 'SELECT',
1848: token2 => 'TABLE',
1849: value2 => 'FA_ASSET_HISTORY'
1850: ,p_log_level_rec => p_log_level_rec);
1851:
1852: return FALSE;
1853: