APPS.POR_VIEW_REQS_PKG dependencies on FND_USER

Line 23: fnd_user fnd,

19: * ******************************************SELECT pap.full_name, pap.email_address, ph.phone_number, wn.begin_date
20: FROM
21: wf_notifications wn,
22: wf_user_roles wlur,
23: fnd_user fnd,
24: po_requisition_headers_all prh,
25: per_phones ph,
26: per_all_people_f pap
27: WHERE

Line 32: wlur.user_name = fnd.user_name AND

28: prh.requisition_header_id = 140331 AND
29: ph.parent_table(+) = 'PER_ALL_PEOPLE_F' AND
30: ph.parent_id (+) = fnd.employee_id AND
31: ph.phone_type(+) = 'W1' AND
32: wlur.user_name = fnd.user_name AND
33: pap.person_id = fnd.employee_id AND
34: fnd.employee_id = 57 AND
35: wn.recipient_role = wlur.role_name AND
36: wn.status = 'OPEN' AND

Line 1498: fnd_user fnd,

1494: FROM
1495: wf_notifications wn,
1496: wf_notification_attributes wna,
1497: wf_user_roles wlur,
1498: fnd_user fnd,
1499: po_requisition_headers_all prh,
1500: per_all_people_f pap
1501: WHERE
1502: prh.requisition_header_id = req_header_id AND

Line 1503: wlur.user_name = fnd.user_name AND

1499: po_requisition_headers_all prh,
1500: per_all_people_f pap
1501: WHERE
1502: prh.requisition_header_id = req_header_id AND
1503: wlur.user_name = fnd.user_name AND
1504: pap.person_id = fnd.employee_id AND
1505: fnd.employee_id = l_approver_id AND
1506: prh.requisition_header_id = wna.number_value AND
1507: wna.name = 'DOCUMENT_ID' AND