APPS.FA_ASSET_VAL_PVT dependencies on FA_LOOKUPS_B

Line 2608: from fa_lookups_b

2604: BEGIN
2605:
2606: select count(*)
2607: into l_count
2608: from fa_lookups_b
2609: where lookup_type = p_lookup_type
2610: and lookup_code = p_lookup_code;
2611:
2612: if (l_count <> 0) then

Line 2913: from fa_lookups_b

2909: BEGIN
2910: if p_property_type_code is not null then
2911: select count(1)
2912: into l_count
2913: from fa_lookups_b
2914: where lookup_type = 'PROPERTY TYPE'
2915: and lookup_code = p_property_type_code;
2916:
2917: if l_count = 0 then

Line 2937: from fa_lookups_b

2933: BEGIN
2934: if p_1245_1250_code is not null then
2935: select count(1)
2936: into l_count
2937: from fa_lookups_b
2938: where lookup_type = '1245/1250 PROPERTY'
2939: and lookup_code = p_1245_1250_code;
2940:
2941: if l_count = 0 then