APPS.PA_FUNDS_CONTROL_PKG1 dependencies on PO_REQUISITION_LINES_ALL

Line 2691: FROM po_requisition_lines_all porl

2687: AND pogt.distribution_id = pobc.distribution_id
2688: AND pogt.distribution_type = pobc.distribution_type
2689: AND nvl(pogt.reference15,-999999)= nvl(pobc.reference15,-999999) --Bug 12984297
2690: AND EXISTS ( SELECT 1
2691: FROM po_requisition_lines_all porl
2692: WHERE nvl(porl.DESTINATION_TYPE_CODE,'EXPENSE') = 'EXPENSE'
2693: AND porl.requisition_line_id = pobc.line_id
2694: AND pobc.distribution_type = 'REQUISITION'
2695: UNION ALL

Line 3266: po_requisition_lines_all porl

3262: CURSOR cur_req_vend_org_details (p_req_line_id IN NUMBER )IS
3263: SELECT pov.vendor_id,
3264: porl.org_id
3265: FROM po_vendors pov,
3266: po_requisition_lines_all porl
3267: WHERE pov.vendor_name (+) = porl.suggested_vendor_name
3268: AND porl.REQUISITION_LINE_ID =p_req_line_id;
3269:
3270: -- Cursor to fetch Vendor and organization details for PO line

Line 3301: l_old_req_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;

3297:
3298: l_index NUMBER;
3299: l_count_success_rec NUMBER;
3300:
3301: l_old_req_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
3302: l_old_po_header_id PO_HEADERS_ALL.po_HEADER_ID%TYPE;
3303: l_req_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
3304: l_req_org_id PO_HEADERS_ALL.ORG_ID%TYPE;
3305: l_Po_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;