DBA Data[Home] [Help]

APPS.PA_CHECK_COMMITMENTS dependencies on GL_LEDGERS

Line 22: FROM GL_LEDGERS GLSLA,

18: SELECT 'Y' /* to find whether cash basis accounting is enabled or not */
19: FROM DUAL
20: WHERE EXISTS (
21: SELECT NVL(GLSLA.SLA_LEDGER_CASH_BASIS_FLAG,'N')
22: FROM GL_LEDGERS GLSLA,
23: PA_IMPLEMENTATIONS_ALL IMP,
24: AP_INVOICE_DISTRIBUTIONS_ALL APD
25: WHERE NVL(GLSLA.SLA_LEDGER_CASH_BASIS_FLAG,'N') = 'Y'
26: AND GLSLA.LEDGER_ID = IMP.SET_OF_BOOKS_ID

Line 363: , GL_LEDGERS G /* Added for bug 3537697 */

359: , PA_EXPENDITURE_TYPES ET
360: , PA_TASKS T
361: , PO_DISTRIBUTIONS_ALL POD
362: , PA_PROJECTS P
363: , GL_LEDGERS G /* Added for bug 3537697 */
364: WHERE
365: /* POH.VENDOR_ID = V.VENDOR_ID (+) Removed join for bug 1751445 */
366: POH.AGENT_ID = BUY.PERSON_ID
367: AND TRUNC(SYSDATE)

Line 1203: , GL_LEDGERS G

1199: , PO_HEADERS_ALL POH
1200: , PO_LINE_LOCATIONS_ALL PLL
1201: , PO_DISTRIBUTIONS_ALL POD
1202: , PO_LINES_ALL POL
1203: , GL_LEDGERS G
1204: WHERE PJPO.PROJECT_ID = p_ProjectID
1205: AND PJPO.PO_Header_ID = POH.PO_Header_ID
1206: AND POL.PO_Header_ID = POH.PO_Header_ID
1207: AND POD.Distribution_type <> 'PREPAYMENT'