APPS.PA_CHECK_COMMITMENTS dependencies on PER_ALL_PEOPLE_F

Line 116: 1. Altered the table sequence. 2. replaced per_people_f with per_all_people_f

112: for new Purchase Requisitions
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';

Line 132: , PER_ALL_PEOPLE_F REQ

128: SELECT '1'
129: FROM
130: PO_REQ_DISTRIBUTIONS_ALL RD
131: , PO_REQUISITION_LINES_ALL RL
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

Line 275: /* , PER_ALL_PEOPLE_F BUY

271: , PO_LINES_ALL POL
272: , PO_RELEASES_ALL POR
273: , PO_DOCUMENT_TYPES_TL PDT --/* added for bug 6367516 */
274: , PO_LINE_LOCATIONS_ALL PLL
275: /* , PER_ALL_PEOPLE_F BUY
276: , PER_ALL_PEOPLE_F REQ *//* commented for bug 11800494 */
277: WHERE
278: /* POH.AGENT_ID = BUY.PERSON_ID
279: AND */ POD.Distribution_type <> 'PREPAYMENT' /* commented for bug 11800494 */

Line 276: , PER_ALL_PEOPLE_F REQ *//* commented for bug 11800494 */

272: , PO_RELEASES_ALL POR
273: , PO_DOCUMENT_TYPES_TL PDT --/* added for bug 6367516 */
274: , PO_LINE_LOCATIONS_ALL PLL
275: /* , PER_ALL_PEOPLE_F BUY
276: , PER_ALL_PEOPLE_F REQ *//* commented for bug 11800494 */
277: WHERE
278: /* POH.AGENT_ID = BUY.PERSON_ID
279: AND */ POD.Distribution_type <> 'PREPAYMENT' /* commented for bug 11800494 */
280: /* AND TRUNC(SYSDATE)

Line 356: , PER_ALL_PEOPLE_F BUY

352: /* , PO_VENDORS V Removed for bug 1751445 */
353: , PO_LINES_ALL POL
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

Line 357: , PER_ALL_PEOPLE_F REQ

353: , PO_LINES_ALL POL
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

Line 592: , PER_ALL_PEOPLE_F REQ

588: , PO_REQUISITION_LINES_ALL RL
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