DBA Data[Home] [Help]

APPS.PA_CHECK_COMMITMENTS dependencies on PA_TASKS

Line 82: pa_tasks T

78: FROM DUAL
79: WHERE EXISTS (
80: SELECT enc1.encumbrance_item_id
81: FROM gms_encumbrance_items_all Enc1,
82: pa_tasks T
83: WHERE enc1.task_id = T.task_id
84: AND T.project_id = p_ProjectID
85: AND enc1.enc_distributed_flag = 'Y'
86: MINUS

Line 136: , PA_TASKS T

132: , PER_ALL_PEOPLE_F REQ
133: , PO_REQUISITION_HEADERS_ALL RH
134: , PO_DOCUMENT_TYPES_ALL_TL PDT /* modified for bug 4758887 */
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

Line 360: , PA_TASKS T

356: , PER_ALL_PEOPLE_F BUY
357: , PER_ALL_PEOPLE_F REQ
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

Line 501: , PA_TASKS T

497: , PO_VENDORS V
498: , HR_ALL_ORGANIZATION_UNITS O
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

Line 593: , PA_TASKS T

589: , PO_REQUISITION_HEADERS_ALL RH
590: , PO_DOCUMENT_TYPES_ALL_TL PDT /* modified for bug 4758887 */
591: , PO_LINE_TYPES_B LT /* modified for bug 6367516 */
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