APPS.PO_WF_REQ_NOTIFICATION dependencies on PER_ALL_PEOPLE_F

Line 1228: per_all_people_f per -- Bug 3404451

1224: FROM po_requisition_lines rql,
1225: mtl_system_items_kfv msi,
1226: hr_locations_all hrt,
1227: mtl_units_of_measure muom, -- bug 2401933.add
1228: per_all_people_f per -- Bug 3404451
1229: WHERE rql.requisition_header_id = v_document_id
1230: AND NVL(rql.cancel_flag,'N') = 'N'
1231: AND NVL(rql.modified_by_agent_flag, 'N') = 'N'
1232: AND hrt.location_id (+) = rql.deliver_to_location_id

Line 1480: per_all_people_f per, -- Bug 3404451

1476: rql.currency_unit_price
1477: FROM po_requisition_lines rql,
1478: mtl_system_items_kfv msi,
1479: hr_locations_all hrt,
1480: per_all_people_f per, -- Bug 3404451
1481: mtl_units_of_measure muom, -- bug 2401933.add
1482: org_organization_definitions org
1483: WHERE rql.requisition_header_id = v_document_id
1484: AND NVL(rql.cancel_flag,'N') = 'N'

Line 1917: per_all_people_f per, -- Bug 3404451

1913: poh.employee_id, /* bug 2788683 */
1914: poh.created_by, /* bug 2788683 */
1915: poh.action_code /* bug 3090563 */
1916: from po_action_history poh,
1917: per_all_people_f per, -- Bug 3404451
1918: po_lookup_codes polc
1919: where OBJECT_TYPE_CODE = v_object_type
1920: and nvl(poh.action_code, 'PENDING') = polc.lookup_code
1921: and POLC.LOOKUP_TYPE = 'APPR_HIST_ACTIONS'

Line 1938: per_all_people_f per,

1934:
1935: CURSOR count_rows(v_document_id NUMBER, v_object_type VARCHAR2) IS
1936: SELECT count(*)
1937: from po_action_history poh,
1938: per_all_people_f per,
1939: po_lookup_codes polc
1940: where OBJECT_TYPE_CODE = v_object_type
1941: and nvl(poh.action_code, 'PENDING') = polc.lookup_code
1942: and POLC.LOOKUP_TYPE = 'APPR_HIST_ACTIONS'

Line 2165: FROM per_all_people_f per, -- Bug 3404451

2161: CURSOR pending_csr(v_document_id NUMBER, v_object_type VARCHAR2) IS
2162:
2163: SELECT pal.SEQUENCE_NUM,per.FULL_NAME,null,null,null,null,
2164: NULL, NULL, NULL /* bug 2788683*/
2165: FROM per_all_people_f per, -- Bug 3404451
2166: po_approval_list_lines pal,
2167: po_approval_list_headers pah
2168: WHERE pah.document_id = v_document_id
2169: and pah.document_type = v_object_type

Line 2180: FROM per_all_people_f per,

2176: ORDER BY 1 desc;
2177:
2178: CURSOR count_rows(v_document_id NUMBER, v_object_type VARCHAR2) IS
2179: SELECT count(*)
2180: FROM per_all_people_f per,
2181: po_approval_list_lines pal,
2182: po_approval_list_headers pah
2183: WHERE pah.document_id = v_document_id
2184: and pah.document_type = v_object_type

Line 2271: into fullName from per_all_people_f

2267: for i in reverse 1 .. upperLimit loop
2268:
2269: if(approverList(i).person_id is not null and approverList(i).approval_status is null) then
2270: select full_name
2271: into fullName from per_all_people_f
2272: where person_id = approverList(i).person_id
2273: and trunc(sysdate) between effective_start_date and effective_end_date;
2274:
2275: l_history_seq := l_history_seq + 1;

Line 2347: per_all_people_f per, -- Bug 3404451

2343: poh.OBJECT_REVISION_NUM,
2344: poh.employee_id, /* bug 2788683 */
2345: poh.created_by /* bug 2788683 */
2346: from po_action_history poh,
2347: per_all_people_f per, -- Bug 3404451
2348: po_lookup_codes polc
2349: where OBJECT_TYPE_CODE = v_object_type
2350: and poh.action_code = polc.lookup_code
2351: and POLC.LOOKUP_TYPE IN ('APPROVER ACTIONS','CONTROL ACTIONS')

Line 2366: per_all_people_f per -- Bug 3404451

2362: poh.OBJECT_REVISION_NUM,
2363: poh.employee_id, /* bug 2788683 */
2364: poh.created_by /* bug 2788683 */
2365: from po_action_history poh,
2366: per_all_people_f per -- Bug 3404451
2367: where OBJECT_TYPE_CODE = v_object_type
2368: and poh.action_code is null
2369: and per.person_id(+) = poh.employee_id /* bug 2788683 */
2370: and trunc(sysdate) between per.effective_start_date(+)