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 1916: per_all_people_f per, -- Bug 3404451

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

Line 2126: FROM per_all_people_f per, -- Bug 3404451

2122: CURSOR pending_csr(v_document_id NUMBER, v_object_type VARCHAR2) IS
2123:
2124: SELECT pal.SEQUENCE_NUM,per.FULL_NAME,null,null,null,null,
2125: NULL, NULL, NULL /* bug 2788683*/
2126: FROM per_all_people_f per, -- Bug 3404451
2127: po_approval_list_lines pal,
2128: po_approval_list_headers pah
2129: WHERE pah.document_id = v_document_id
2130: and pah.document_type = v_object_type

Line 2212: into fullName from per_all_people_f

2208: for i in 1 .. upperLimit loop
2209:
2210: if(approverList(i).person_id is not null and approverList(i).approval_status is null) then
2211: select full_name
2212: into fullName from per_all_people_f
2213: where person_id = approverList(i).person_id
2214: and trunc(sysdate) between effective_start_date and effective_end_date;
2215:
2216: l_history_seq := l_history_seq + 1;

Line 2288: per_all_people_f per, -- Bug 3404451

2284: poh.OBJECT_REVISION_NUM,
2285: poh.employee_id, /* bug 2788683 */
2286: poh.created_by /* bug 2788683 */
2287: from po_action_history poh,
2288: per_all_people_f per, -- Bug 3404451
2289: po_lookup_codes polc
2290: where OBJECT_TYPE_CODE = v_object_type
2291: and poh.action_code = polc.lookup_code
2292: and POLC.LOOKUP_TYPE IN ('APPROVER ACTIONS','CONTROL ACTIONS')

Line 2307: per_all_people_f per -- Bug 3404451

2303: poh.OBJECT_REVISION_NUM,
2304: poh.employee_id, /* bug 2788683 */
2305: poh.created_by /* bug 2788683 */
2306: from po_action_history poh,
2307: per_all_people_f per -- Bug 3404451
2308: where OBJECT_TYPE_CODE = v_object_type
2309: and poh.action_code is null
2310: and per.person_id(+) = poh.employee_id /* bug 2788683 */
2311: and trunc(sysdate) between per.effective_start_date(+)