APPS.PO_WF_PO_NOTIFICATION dependencies on PER_ALL_PEOPLE_F

Line 22: l_forwarded_from per_all_people_f.full_name%TYPE;

18: l_header_msg VARCHAR2(500);
19: l_po_amount VARCHAR2(30);
20: l_tax_amount VARCHAR2(30);
21: l_description po_headers.comments%TYPE;
22: l_forwarded_from per_all_people_f.full_name%TYPE;
23: l_preparer per_all_people_f.full_name%TYPE;
24: --
25: -- l_note VARCHAR2(480); /* < UTF8 FPI - changed from VARCHAR2(240) > */
26: l_note po_action_history.note%TYPE;

Line 23: l_preparer per_all_people_f.full_name%TYPE;

19: l_po_amount VARCHAR2(30);
20: l_tax_amount VARCHAR2(30);
21: l_description po_headers.comments%TYPE;
22: l_forwarded_from per_all_people_f.full_name%TYPE;
23: l_preparer per_all_people_f.full_name%TYPE;
24: --
25: -- l_note VARCHAR2(480); /* < UTF8 FPI - changed from VARCHAR2(240) > */
26: l_note po_action_history.note%TYPE;
27: --

Line 981: TYPE full_name_tbl_type IS TABLE OF PER_ALL_PEOPLE_F.full_name%TYPE;

977: -- Declare TABLEs for each column that is selected
978: -- from history_csr cursor.
979: --
980: TYPE sequence_num_tbl_type IS TABLE OF PO_ACTION_HISTORY.sequence_num%TYPE;
981: TYPE full_name_tbl_type IS TABLE OF PER_ALL_PEOPLE_F.full_name%TYPE;
982: TYPE displayed_field_tbl_type IS TABLE OF PO_LOOKUP_CODES.displayed_field%TYPE;
983: TYPE action_date_tbl_type IS TABLE OF PO_ACTION_HISTORY.action_date%TYPE;
984: TYPE note_tbl_type IS TABLE OF PO_ACTION_HISTORY.note%TYPE;
985: TYPE object_revision_num_tbl_type IS TABLE OF PO_ACTION_HISTORY.object_revision_num%TYPE;

Line 1012: per_all_people_f per, -- Bug 3404451

1008: poh.OBJECT_REVISION_NUM,
1009: poh.employee_id, /* bug 2788683 */
1010: poh.created_by /* bug 2788683 */
1011: from po_action_history poh,
1012: per_all_people_f per, -- Bug 3404451
1013: po_lookup_codes polc
1014: where OBJECT_TYPE_CODE = v_doc_type_code
1015: and poh.action_code = polc.lookup_code
1016: and POLC.LOOKUP_TYPE IN ('APPROVER ACTIONS','CONTROL ACTIONS')

Line 1031: per_all_people_f per -- Bug 3404451

1027: poh.OBJECT_REVISION_NUM,
1028: poh.employee_id, /* bug 2788683 */
1029: poh.created_by /* bug 2788683 */
1030: from po_action_history poh,
1031: per_all_people_f per -- Bug 3404451
1032: where OBJECT_TYPE_CODE = v_doc_type_code
1033: and poh.action_code is null
1034: and per.person_id(+) = poh.employee_id /* bug 2788683 */
1035: and trunc(sysdate) between per.effective_start_date(+)