APPS.PA_FAXFACE dependencies on PA_IMPLEMENTATIONS

Line 4574: from pa_implementations;

4570:
4571:
4572: select set_of_books_id
4573: into l_ledger_id
4574: from pa_implementations;
4575:
4576:
4577: FOR projrec IN selprjs LOOP
4578:

Line 5258: from pa_implementations;

5254: retcode :=0;
5255:
5256: select set_of_books_id
5257: into l_ledger_id
5258: from pa_implementations;
5259:
5260: FOR projrec IN selprjs LOOP
5261:
5262: BEGIN

Line 5601: pa_implementations pi

5597: CURSOR deprn_expense_cur IS
5598: SELECT 'Deprn Expense Acct code combination is valid'
5599: FROM gl_code_combinations gcc,
5600: gl_sets_of_books gsob,
5601: pa_implementations pi
5602: WHERE gcc.code_combination_id = l_new_deprn_expense_ccid
5603: AND gcc.chart_of_accounts_id = gsob.chart_of_accounts_id
5604: AND gsob.set_of_books_id = pi.set_of_books_id
5605: AND gcc.account_type = 'E';

Line 5762: pa_implementations pi

5758: --Used to determine if the book type code is valid for the current SOB
5759: CURSOR book_type_code_cur (x_book_type_code VARCHAR2) IS
5760: SELECT fb.set_of_books_id
5761: FROM fa_book_controls fb,
5762: pa_implementations pi
5763: WHERE fb.set_of_books_id = pi.set_of_books_id
5764: AND fb.book_type_code = x_book_type_code;
5765:
5766: book_type_code_rec book_type_code_cur%ROWTYPE;

Line 6144: pa_implementations imp,

6140:
6141: CURSOR c_alc_ledger IS
6142: SELECT gl.ledger_id, gl.currency_code, imp.set_of_books_id, gl.org_id, gld.sla_ledger_cash_basis_flag
6143: FROM gl_alc_ledger_rships_v gl,
6144: pa_implementations imp,
6145: gl_ledgers gld
6146: WHERE gl.source_ledger_id = imp.set_of_books_id
6147: AND gl.application_id = 275
6148: --AND gl.org_id = imp.org_id commented for the bug 9649314

Line 6481: pa_implementations imp

6477:
6478: CURSOR c_alc_ledger IS
6479: SELECT gl.ledger_id, gl.currency_code
6480: FROM gl_alc_ledger_rships_v gl,
6481: pa_implementations imp
6482: WHERE gl.source_ledger_id = imp.set_of_books_id
6483: AND gl.application_id = 275
6484: --AND gl.org_id = imp.org_id commented for the bug 9649314
6485: AND gl.relationship_enabled_flag = 'Y';

Line 6580: pa_implementations imp

6576:
6577: CURSOR c_alc_ledger IS
6578: SELECT gl.ledger_id, gl.currency_code
6579: FROM gl_alc_ledger_rships_v gl,
6580: pa_implementations imp
6581: WHERE gl.source_ledger_id = imp.set_of_books_id
6582: AND gl.application_id = 275
6583: --AND gl.org_id = imp.org_id commented for the bug 9649314
6584: AND gl.relationship_enabled_flag = 'Y';

Line 6617: pa_implementations imp

6613:
6614: CURSOR c_alc_ledger IS
6615: SELECT gl.ledger_id, gl.currency_code
6616: FROM gl_alc_ledger_rships_v gl,
6617: pa_implementations imp
6618: WHERE gl.source_ledger_id = imp.set_of_books_id
6619: AND gl.application_id = 275
6620: --AND gl.org_id = imp.org_id commented for the bug 9649314
6621: AND gl.relationship_enabled_flag = 'Y';