APPS.IPA_ASSET_MECH_APIS_PKG dependencies on PA_IMPLEMENTATIONS

Line 191: from fa_book_controls bc, fa_category_books cb, pa_implementations pi

187: where upper(segment1||segment2||segment3||segment4||segment5||segment6||segment7) = upper(v_asset_location);
188:
189: cursor get_book_type IS
190: select bc.book_type_code
191: from fa_book_controls bc, fa_category_books cb, pa_implementations pi
192: where cb.category_id = v_category_id
193: and cb.book_type_code = bc.book_type_code
194: and bc.book_class = 'CORPORATE'
195: and pi.set_of_books_id = bc.set_of_books_id;

Line 237: from pa_implementations;

233: x_err_stage := 'ipa_get_org';
234:
235: select org_id
236: into v_org_id
237: from pa_implementations;
238:
239: x_err_stage := 'ipa_get_name_method';
240:
241: open get_asset_naming_method;

Line 368: --Get Book_Type_Code from Pa_Implementations, If NULL then derive from FA.

364:
365: --Book Type Code
366:
367: --Bug 3068204
368: --Get Book_Type_Code from Pa_Implementations, If NULL then derive from FA.
369:
370: Select Book_Type_Code
371: Into V_Book_Type_Code
372: From Pa_Implementations;

Line 372: From Pa_Implementations;

368: --Get Book_Type_Code from Pa_Implementations, If NULL then derive from FA.
369:
370: Select Book_Type_Code
371: Into V_Book_Type_Code
372: From Pa_Implementations;
373:
374: --Bug 3068204
375: If V_Book_Type_Code is NULL Then
376: open get_book_type;