APPS.PA_FAXFACE dependencies on PA_IMPLEMENTATIONS

Line 4190: from pa_implementations;

4186:
4187:
4188: select set_of_books_id
4189: into l_ledger_id
4190: from pa_implementations;
4191:
4192:
4193: FOR projrec IN selprjs LOOP
4194:

Line 4872: from pa_implementations;

4868: retcode :=0;
4869:
4870: select set_of_books_id
4871: into l_ledger_id
4872: from pa_implementations;
4873:
4874: FOR projrec IN selprjs LOOP
4875:
4876: BEGIN

Line 5215: pa_implementations pi

5211: CURSOR deprn_expense_cur IS
5212: SELECT 'Deprn Expense Acct code combination is valid'
5213: FROM gl_code_combinations gcc,
5214: gl_sets_of_books gsob,
5215: pa_implementations pi
5216: WHERE gcc.code_combination_id = l_new_deprn_expense_ccid
5217: AND gcc.chart_of_accounts_id = gsob.chart_of_accounts_id
5218: AND gsob.set_of_books_id = pi.set_of_books_id
5219: AND gcc.account_type = 'E';

Line 5376: pa_implementations pi

5372: --Used to determine if the book type code is valid for the current SOB
5373: CURSOR book_type_code_cur (x_book_type_code VARCHAR2) IS
5374: SELECT fb.set_of_books_id
5375: FROM fa_book_controls fb,
5376: pa_implementations pi
5377: WHERE fb.set_of_books_id = pi.set_of_books_id
5378: AND fb.book_type_code = x_book_type_code;
5379:
5380: book_type_code_rec book_type_code_cur%ROWTYPE;

Line 5723: pa_implementations imp,

5719:
5720: CURSOR c_alc_ledger IS
5721: SELECT gl.ledger_id, gl.currency_code, imp.set_of_books_id, imp.org_id, gld.sla_ledger_cash_basis_flag
5722: FROM gl_alc_ledger_rships_v gl,
5723: pa_implementations imp,
5724: gl_ledgers gld
5725: WHERE gl.source_ledger_id = imp.set_of_books_id
5726: AND gl.application_id = 275
5727: AND gl.org_id = imp.org_id

Line 6035: pa_implementations imp

6031:
6032: CURSOR c_alc_ledger IS
6033: SELECT gl.ledger_id, gl.currency_code
6034: FROM gl_alc_ledger_rships_v gl,
6035: pa_implementations imp
6036: WHERE gl.source_ledger_id = imp.set_of_books_id
6037: AND gl.application_id = 275
6038: AND gl.org_id = imp.org_id
6039: AND gl.relationship_enabled_flag = 'Y';

Line 6133: pa_implementations imp

6129:
6130: CURSOR c_alc_ledger IS
6131: SELECT gl.ledger_id, gl.currency_code
6132: FROM gl_alc_ledger_rships_v gl,
6133: pa_implementations imp
6134: WHERE gl.source_ledger_id = imp.set_of_books_id
6135: AND gl.application_id = 275
6136: AND gl.org_id = imp.org_id
6137: AND gl.relationship_enabled_flag = 'Y';

Line 6170: pa_implementations imp

6166:
6167: CURSOR c_alc_ledger IS
6168: SELECT gl.ledger_id, gl.currency_code
6169: FROM gl_alc_ledger_rships_v gl,
6170: pa_implementations imp
6171: WHERE gl.source_ledger_id = imp.set_of_books_id
6172: AND gl.application_id = 275
6173: AND gl.org_id = imp.org_id
6174: AND gl.relationship_enabled_flag = 'Y';