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 1621: fnd_user fnd,

1617: FROM
1618: wf_notifications wn,
1619: wf_notification_attributes wna,
1620: wf_user_roles wlur,
1621: fnd_user fnd,
1622: po_requisition_headers_all prh,
1623: per_all_people_f pap
1624: WHERE
1625: prh.requisition_header_id = req_header_id AND

Line 1626: wlur.user_name = fnd.user_name AND

1622: po_requisition_headers_all prh,
1623: per_all_people_f pap
1624: WHERE
1625: prh.requisition_header_id = req_header_id AND
1626: wlur.user_name = fnd.user_name AND
1627: pap.person_id = fnd.employee_id AND
1628: fnd.employee_id = l_approver_id AND
1629: prh.requisition_header_id = wna.number_value AND
1630: wna.name = 'DOCUMENT_ID' AND