APPS.PA_PROJECT_ASSETS_PUB dependencies on FA_CATEGORIES

Line 198: FROM fa_categories

194:
195: --Used to determine if the asset category is valid
196: CURSOR asset_category_cur IS
197: SELECT 'Asset Category is valid'
198: FROM fa_categories
199: WHERE category_id = p_asset_category_id
200: AND enabled_flag = 'Y';
201:
202: asset_category_rec asset_category_cur%ROWTYPE;

Line 1063: --If Asset Category is specified, it must be valid in FA_CATEGORIES

1059:
1060: END IF;
1061:
1062:
1063: --If Asset Category is specified, it must be valid in FA_CATEGORIES
1064: IF p_asset_category_id IS NOT NULL AND p_asset_category_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
1065: OPEN asset_category_cur;
1066: FETCH asset_category_cur INTO asset_category_rec;
1067: IF asset_category_cur%NOTFOUND THEN

Line 2997: FROM fa_categories

2993:
2994: --Used to determine if the asset category is valid
2995: CURSOR asset_category_cur IS
2996: SELECT 'Asset Category is valid'
2997: FROM fa_categories
2998: WHERE category_id = p_asset_category_id
2999: AND enabled_flag = 'Y';
3000:
3001: asset_category_rec asset_category_cur%ROWTYPE;