DBA Data[Home] [Help]

APPS.PA_CHECK_COMMITMENTS dependencies on PA_PROJECTS

Line 139: , PA_PROJECTS P

135: , PO_LINE_TYPES_B LT /* modified for bug 6367516 */
136: , PA_TASKS T
137: , HR_ALL_ORGANIZATION_UNITS O
138: , PA_EXPENDITURE_TYPES ET
139: , PA_PROJECTS P
140: WHERE
141: RH.REQUISITION_HEADER_ID = RL.REQUISITION_HEADER_ID
142: AND RH.TYPE_LOOKUP_CODE = 'PURCHASE'
143: AND PDT.DOCUMENT_TYPE_CODE = 'REQUISITION'

Line 362: , PA_PROJECTS P

358: , HR_ALL_ORGANIZATION_UNITS O
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

Line 503: , PA_PROJECTS P

499: , PA_EXPEND_TYP_SYS_LINKS ES
500: , PA_EXPENDITURE_TYPES ET
501: , PA_TASKS T
502: , PO_DISTRIBUTIONS PO
503: , PA_PROJECTS P
504: WHERE
505: I.vendor_id = V.vendor_id
506: AND I.invoice_id = D.invoice_id
507: AND decode(D.pa_addition_flag,'Z','Y','T','Y','E','Y', null,'N',D.pa_addition_flag) <> 'Y'

Line 596: , PA_PROJECTS P

592: , PER_ALL_PEOPLE_F REQ
593: , PA_TASKS T
594: , HR_ALL_ORGANIZATION_UNITS O
595: , PA_EXPENDITURE_TYPES ET
596: , PA_PROJECTS P
597: WHERE
598: RH.REQUISITION_HEADER_ID = RL.REQUISITION_HEADER_ID
599: AND RH.TYPE_LOOKUP_CODE = 'PURCHASE'
600: AND PDT.DOCUMENT_TYPE_CODE = 'REQUISITION'