APPS.PA_PROJECT_ASSETS_PUB dependencies on FA_ADDITIONS

Line 253: FROM fa_additions

249:
250: --Used to determine if Tag Number is unique in Oracle Assets
251: CURSOR unique_tag_number_fa_cur IS
252: SELECT 'Tag Number Exists'
253: FROM fa_additions
254: WHERE tag_number = p_tag_number;
255:
256: unique_tag_number_fa_rec unique_tag_number_fa_cur%ROWTYPE;
257:

Line 271: FROM fa_additions

267:
268: --Used to determine if Parent Asset ID is valid in Oracle Assets
269: CURSOR parent_asset_cur IS
270: SELECT 'Parent Asset Number Exists'
271: FROM fa_additions
272: WHERE asset_id = p_parent_asset_id
273: AND asset_type <> 'GROUP';
274:
275: parent_asset_rec parent_asset_cur%ROWTYPE;

Line 281: FROM fa_additions fa,

277:
278: --Used to determine if Parent Asset ID is valid for Book specified
279: CURSOR parent_asset_book_cur IS
280: SELECT 'Parent Asset Number Exists in Book'
281: FROM fa_additions fa,
282: fa_books fb
283: WHERE fa.asset_id = p_parent_asset_id
284: AND fa.asset_type <> 'GROUP'
285: AND fa.asset_id = fb.asset_id

Line 296: fa_additions fa

292: --Used to determine if the Ret Target Asset ID is a valid GROUP asset in the book
293: CURSOR ret_target_cur IS
294: SELECT fa.asset_category_id
295: FROM fa_books fb,
296: fa_additions fa
297: WHERE fa.asset_id = p_ret_target_asset_id
298: AND fa.asset_type = 'GROUP'
299: AND fa.asset_id = fb.asset_id
300: AND fb.book_type_code = l_asset_in_rec.book_type_code

Line 2939: FROM fa_additions

2935:
2936: --Used to determine if Tag Number is unique in Oracle Assets
2937: CURSOR unique_tag_number_fa_cur IS
2938: SELECT 'Tag Number Exists'
2939: FROM fa_additions
2940: WHERE tag_number = p_tag_number;
2941:
2942: unique_tag_number_fa_rec unique_tag_number_fa_cur%ROWTYPE;
2943:

Line 3014: FROM fa_additions

3010:
3011: --Used to determine if Parent Asset ID is valid in Oracle Assets
3012: CURSOR parent_asset_cur IS
3013: SELECT 'Parent Asset Number Exists'
3014: FROM fa_additions
3015: WHERE asset_id = p_parent_asset_id
3016: AND asset_type <> 'GROUP';
3017:
3018: parent_asset_rec parent_asset_cur%ROWTYPE;

Line 3024: FROM fa_additions fa,

3020:
3021: --Used to determine if Parent Asset ID is valid for Book specified
3022: CURSOR parent_asset_book_cur(x_parent_asset_id NUMBER) IS
3023: SELECT 'Parent Asset Number Exists in Book'
3024: FROM fa_additions fa,
3025: fa_books fb
3026: WHERE fa.asset_id = x_parent_asset_id
3027: AND fa.asset_type <> 'GROUP'
3028: AND fa.asset_id = fb.asset_id

Line 3085: fa_additions fa

3081: --Used to determine if the Ret Target Asset ID is a valid GROUP asset in the book
3082: CURSOR ret_target_cur IS
3083: SELECT fa.asset_category_id
3084: FROM fa_books fb,
3085: fa_additions fa
3086: WHERE fa.asset_id = p_ret_target_asset_id
3087: AND fa.asset_type = 'GROUP'
3088: AND fa.asset_id = fb.asset_id
3089: AND fb.book_type_code = l_book_type_code