APPS.PO_APPROVAL_REMINDER_SV dependencies on PO_REQUISITION_LINES

Line 111: FROM po_requisition_lines prl

107: -- Bug fix 14083505 - START: Cancelled lines and the lines which are already part of a PO can be ignored
108: AND EXISTS
109: (
110: SELECT 1
111: FROM po_requisition_lines prl
112: WHERE
113: prl.REQUISITION_HEADER_ID = prh.REQUISITION_HEADER_ID
114: AND Nvl(prl.CANCEL_FLAG,'N') <>'Y'
115: AND NVL(prl.closed_code,'OPEN') <> 'FINALLY CLOSED' --Bug 14363353 fix

Line 3288: l_requester_id PO_REQUISITION_LINES.to_person_id%TYPE;

3284: l_tl_line_rec l_temp_labor_lines_csr%ROWTYPE;
3285: l_amount_threshold NUMBER;
3286: l_completion_threshold NUMBER;
3287: l_contractor_or_job VARCHAR2(500);
3288: l_requester_id PO_REQUISITION_LINES.to_person_id%TYPE;
3289: l_profile_name FND_PROFILE_OPTIONS_VL.profile_option_name%TYPE;
3290: l_user_profile_name FND_PROFILE_OPTIONS_VL.user_profile_option_name%TYPE;
3291: BEGIN
3292: -- Retrieve the profile options for the Reminder thresholds.

Line 3559: po_requisition_lines_all PRL

3555: select PRL.requisition_header_id
3556: INTO l_req_header_id
3557: FROM po_lines POL,
3558: po_line_locations_all PLL,
3559: po_requisition_lines_all PRL
3560: WHERE POL.po_line_id = p_po_line_id
3561: AND POL.po_line_id = PLL.po_line_id
3562: AND PLL.line_location_id = PRL.line_location_id;
3563: