APPS.PO_APPROVAL_REMINDER_SV dependencies on PO_REQUISITION_LINES

Line 3254: l_requester_id PO_REQUISITION_LINES.to_person_id%TYPE;

3250: l_tl_line_rec l_temp_labor_lines_csr%ROWTYPE;
3251: l_amount_threshold NUMBER;
3252: l_completion_threshold NUMBER;
3253: l_contractor_or_job VARCHAR2(500);
3254: l_requester_id PO_REQUISITION_LINES.to_person_id%TYPE;
3255: l_profile_name FND_PROFILE_OPTIONS_VL.profile_option_name%TYPE;
3256: l_user_profile_name FND_PROFILE_OPTIONS_VL.user_profile_option_name%TYPE;
3257: BEGIN
3258: -- Retrieve the profile options for the Reminder thresholds.

Line 3525: po_requisition_lines_all PRL

3521: select PRL.requisition_header_id
3522: INTO l_req_header_id
3523: FROM po_lines POL,
3524: po_line_locations_all PLL,
3525: po_requisition_lines_all PRL
3526: WHERE POL.po_line_id = p_po_line_id
3527: AND POL.po_line_id = PLL.po_line_id
3528: AND PLL.line_location_id = PRL.line_location_id;
3529: