APPS.PA_CHECK_COMMITMENTS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 117: 3. Replace hr_organization_units with hr_all_organization_units

113: */
114:
115: /* Bug 1517186 made chagnes for performance tuning.
116: 1. Altered the table sequence. 2. replaced per_people_f with per_all_people_f
117: 3. Replace hr_organization_units with hr_all_organization_units
118: */
119:
120: v_tmp := 'N';
121:

Line 137: , HR_ALL_ORGANIZATION_UNITS O

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
141: RH.REQUISITION_HEADER_ID = RL.REQUISITION_HEADER_ID

Line 358: , HR_ALL_ORGANIZATION_UNITS O

354: , PO_LINE_TYPES_B LT /* modified for bug 6367516 */
355: , PO_LINE_LOCATIONS_ALL PLL
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

Line 498: , HR_ALL_ORGANIZATION_UNITS O

494: FROM
495: AP_INVOICE_DISTRIBUTIONS_ALL D
496: , AP_INVOICES_ALL I
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

Line 594: , HR_ALL_ORGANIZATION_UNITS O

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
598: RH.REQUISITION_HEADER_ID = RL.REQUISITION_HEADER_ID