DBA Data[Home] [Help]

APPS.PA_FAXFACE dependencies on GL_ALC_LEDGER_RSHIPS_V

Line 5722: FROM gl_alc_ledger_rships_v gl,

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

Line 5879: FROM gl_alc_ledger_rships_v gl

5875: into l_alc_exists
5876: from dual
5877: WHERE NOT EXISTS (
5878: SELECT gl.ledger_id
5879: FROM gl_alc_ledger_rships_v gl
5880: WHERE gl.source_ledger_id = v_alc_ledger.set_of_books_id
5881: AND gl.application_id = decode( l_Acct_Source_Code, 'AP_INV', 200,
5882: 'AP_PAY', 200,
5883: 'AP_APP', 200,

Line 6034: FROM gl_alc_ledger_rships_v gl,

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

Line 6132: FROM gl_alc_ledger_rships_v gl,

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

Line 6169: FROM gl_alc_ledger_rships_v gl,

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