APPS.PO_WF_PO_NOTIFICATION dependencies on PER_ALL_PEOPLE_F

Line 37: l_forwarded_from per_all_people_f.full_name%TYPE;

33: --bug 12396408
34: l_po_amount_numeric NUMBER;
35: l_tax_amount_numeric NUMBER;
36: l_description po_headers.comments%TYPE;
37: l_forwarded_from per_all_people_f.full_name%TYPE;
38: l_preparer per_all_people_f.full_name%TYPE;
39: --
40: -- l_note VARCHAR2(480); /* < UTF8 FPI - changed from VARCHAR2(240) > */
41: l_note po_action_history.note%TYPE;

Line 38: l_preparer per_all_people_f.full_name%TYPE;

34: l_po_amount_numeric NUMBER;
35: l_tax_amount_numeric NUMBER;
36: l_description po_headers.comments%TYPE;
37: l_forwarded_from per_all_people_f.full_name%TYPE;
38: l_preparer per_all_people_f.full_name%TYPE;
39: --
40: -- l_note VARCHAR2(480); /* < UTF8 FPI - changed from VARCHAR2(240) > */
41: l_note po_action_history.note%TYPE;
42: --

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

1240: -- Declare TABLEs for each column that is selected
1241: -- from history_csr cursor.
1242: --
1243: TYPE sequence_num_tbl_type IS TABLE OF PO_ACTION_HISTORY.sequence_num%TYPE;
1244: TYPE full_name_tbl_type IS TABLE OF PER_ALL_PEOPLE_F.full_name%TYPE;
1245: TYPE displayed_field_tbl_type IS TABLE OF PO_LOOKUP_CODES.displayed_field%TYPE;
1246: TYPE action_date_tbl_type IS TABLE OF PO_ACTION_HISTORY.action_date%TYPE;
1247: TYPE note_tbl_type IS TABLE OF PO_ACTION_HISTORY.note%TYPE;
1248: TYPE object_revision_num_tbl_type IS TABLE OF PO_ACTION_HISTORY.object_revision_num%TYPE;

Line 1276: per_all_people_f per, -- Bug 3404451

1272: poh.OBJECT_REVISION_NUM,
1273: poh.employee_id, /* bug 2788683 */
1274: poh.created_by /* bug 2788683 */
1275: from po_action_history poh,
1276: per_all_people_f per, -- Bug 3404451
1277: po_lookup_codes polc
1278: where OBJECT_TYPE_CODE = v_doc_type_code
1279: and poh.object_sub_type_code = v_doc_sub_type_code
1280: and poh.action_code = polc.lookup_code

Line 1296: per_all_people_f per -- Bug 3404451

1292: poh.OBJECT_REVISION_NUM,
1293: poh.employee_id, /* bug 2788683 */
1294: poh.created_by /* bug 2788683 */
1295: from po_action_history poh,
1296: per_all_people_f per -- Bug 3404451
1297: where OBJECT_TYPE_CODE = v_doc_type_code
1298: and poh.object_sub_type_code = v_doc_sub_type_code
1299: and poh.action_code is null
1300: and per.person_id(+) = poh.employee_id /* bug 2788683 */