APPS.PA_FAXFACE dependencies on GL_ALC_LEDGER_RSHIPS_V

Line 6143: FROM gl_alc_ledger_rships_v gl,

6139: /* Selected gl.org_id for bug 14702984 */
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

Line 6325: FROM gl_alc_ledger_rships_v gl

6321: into l_alc_exists
6322: from dual
6323: WHERE NOT EXISTS (
6324: SELECT gl.ledger_id
6325: FROM gl_alc_ledger_rships_v gl
6326: WHERE gl.source_ledger_id = v_alc_ledger.set_of_books_id
6327: AND gl.application_id = decode( l_Acct_Source_Code, 'AP_INV', 200,
6328: 'AP_PAY', 200,
6329: 'AP_APP', 200,

Line 6480: FROM gl_alc_ledger_rships_v gl,

6476: IS
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

Line 6579: FROM gl_alc_ledger_rships_v gl,

6575: IS
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

Line 6616: FROM gl_alc_ledger_rships_v gl,

6612: IS
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