APPS.PO_EMAIL_GENERATE dependencies on PO_DISTRIBUTIONS

Line 125: l_requestor_name po_distributions_print.requestor_name%TYPE;

121: l_cancel_flag po_line_locations_all.cancel_flag%TYPE;
122: l_cancel_date po_line_locations_all.cancel_date%TYPE;
123: l_quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE;
124:
125: l_requestor_name po_distributions_print.requestor_name%TYPE;
126: l_requestor_id po_distributions_print.requestor_id%TYPE;
127:
128: /* Bug 2870932 increased the size */
129: l_phone per_all_people_f.work_telephone%TYPE;

Line 126: l_requestor_id po_distributions_print.requestor_id%TYPE;

122: l_cancel_date po_line_locations_all.cancel_date%TYPE;
123: l_quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE;
124:
125: l_requestor_name po_distributions_print.requestor_name%TYPE;
126: l_requestor_id po_distributions_print.requestor_id%TYPE;
127:
128: /* Bug 2870932 increased the size */
129: l_phone per_all_people_f.work_telephone%TYPE;
130: l_email_address per_all_people_f.email_address%TYPE;

Line 422: FROM po_distributions pdp

418: order by line_num asc;
419:
420: cursor requestor_cursor (v_line_location_id NUMBER) IS
421: select distinct deliver_to_person_id
422: FROM po_distributions pdp
423: WHERE pdp.line_location_id = v_line_location_id;
424:
425: l_document_status varchar2(100);
426:

Line 2485: FROM po_distributions

2481: x_subtype po_headers.type_lookup_code%TYPE;
2482:
2483: cursor po_requestor_cursor (v_po_header_id varchar2) IS
2484: select distinct deliver_to_person_id
2485: FROM po_distributions
2486: WHERE po_header_id = v_po_header_id
2487: AND distribution_type <> 'AGREEMENT'; --
2488:
2489: cursor release_requestor_cursor (v_po_release_id varchar2) IS

Line 2491: FROM po_distributions

2487: AND distribution_type <> 'AGREEMENT'; --
2488:
2489: cursor release_requestor_cursor (v_po_release_id varchar2) IS
2490: select distinct deliver_to_person_id
2491: FROM po_distributions
2492: WHERE po_release_id = v_po_release_id;
2493:
2494:
2495: cursor release_location_id_cursor (v_po_release_id varchar2) IS