APPS.PA_PROJECT_ASSETS_PUB dependencies on PA_IMPLEMENTATIONS

Line 180: pa_implementations pi

176: --Used to determine if the book type code is valid for the current SOB
177: CURSOR book_type_code_cur IS
178: SELECT 'Book Type Code is valid'
179: FROM fa_book_controls fb,
180: pa_implementations pi
181: WHERE fb.set_of_books_id = pi.set_of_books_id
182: AND fb.book_type_code = p_book_type_code
183: AND fb.book_class = 'CORPORATE';
184:

Line 191: FROM pa_implementations pi

187:
188: --Used to identify default book type code, if specified
189: CURSOR default_book_type_code_cur IS
190: SELECT pi.book_type_code
191: FROM pa_implementations pi
192: WHERE pi.book_type_code IS NOT NULL;
193:
194:
195: --Used to determine if the asset category is valid

Line 231: pa_implementations pi

227: CURSOR deprn_expense_cur IS
228: SELECT 'Deprn Expense Acct code combination is valid'
229: FROM gl_code_combinations gcc,
230: gl_sets_of_books gsob,
231: pa_implementations pi
232: WHERE gcc.code_combination_id = l_asset_in_rec.depreciation_expense_ccid
233: AND gcc.chart_of_accounts_id = gsob.chart_of_accounts_id
234: AND gsob.set_of_books_id = pi.set_of_books_id
235: AND gcc.account_type = 'E';

Line 969: --Determine if default book_type_code exists in PA_IMPLEMENTATIONS

965: l_asset_in_rec.book_type_code := p_book_type_code;
966: END IF;
967: CLOSE book_type_code_cur;
968: ELSE
969: --Determine if default book_type_code exists in PA_IMPLEMENTATIONS
970: OPEN default_book_type_code_cur;
971: FETCH default_book_type_code_cur INTO l_asset_in_rec.book_type_code;
972: IF default_book_type_code_cur%NOTFOUND THEN
973:

Line 2979: pa_implementations pi

2975: --Used to determine if the book type code is valid for the current SOB
2976: CURSOR book_type_code_cur IS
2977: SELECT 'Book Type Code is valid'
2978: FROM fa_book_controls fb,
2979: pa_implementations pi
2980: WHERE fb.set_of_books_id = pi.set_of_books_id
2981: AND fb.book_type_code = p_book_type_code
2982: AND fb.book_class = 'CORPORATE';
2983:

Line 2990: FROM pa_implementations pi

2986:
2987: --Used to identify default book type code, if specified
2988: CURSOR default_book_type_code_cur IS
2989: SELECT pi.book_type_code
2990: FROM pa_implementations pi
2991: WHERE pi.book_type_code IS NOT NULL;
2992:
2993:
2994: --Used to determine if the asset category is valid

Line 3062: pa_implementations pi

3058: CURSOR deprn_expense_cur IS
3059: SELECT 'Deprn Expense Acct code combination is valid'
3060: FROM gl_code_combinations gcc,
3061: gl_sets_of_books gsob,
3062: pa_implementations pi
3063: WHERE gcc.code_combination_id = l_depreciation_expense_ccid
3064: AND gcc.chart_of_accounts_id = gsob.chart_of_accounts_id
3065: AND gsob.set_of_books_id = pi.set_of_books_id
3066: AND gcc.account_type = 'E';