APPS.FA_ASSET_VAL_PVT dependencies on FA_LOOKUPS_B

Line 2819: from fa_lookups_b

2815: BEGIN
2816:
2817: select count(*)
2818: into l_count
2819: from fa_lookups_b
2820: where lookup_type = p_lookup_type
2821: and lookup_code = p_lookup_code;
2822:
2823: if (l_count <> 0) then

Line 3118: from fa_lookups_b

3114: BEGIN
3115: if p_property_type_code is not null then
3116: select count(1)
3117: into l_count
3118: from fa_lookups_b
3119: where lookup_type = 'PROPERTY TYPE'
3120: and lookup_code = p_property_type_code;
3121:
3122: if l_count = 0 then

Line 3144: from fa_lookups_b

3140: BEGIN
3141: if p_1245_1250_code is not null then
3142: select count(1)
3143: into l_count
3144: from fa_lookups_b
3145: where lookup_type = '1245/1250 PROPERTY'
3146: and lookup_code = p_1245_1250_code;
3147:
3148: if l_count = 0 then