APPS.PA_FUNDS_CONTROL_PKG1 dependencies on PO_REQUISITION_LINES_ALL

Line 2644: FROM po_requisition_lines_all porl

2640: AND pobc.pa_project_id IS NOT NULL
2641: AND pogt.distribution_id = pobc.distribution_id
2642: AND pogt.distribution_type = pobc.distribution_type
2643: AND EXISTS ( SELECT 1
2644: FROM po_requisition_lines_all porl
2645: WHERE nvl(porl.DESTINATION_TYPE_CODE,'EXPENSE') = 'EXPENSE'
2646: AND porl.requisition_line_id = pobc.line_id
2647: AND pobc.distribution_type = 'REQUISITION'
2648: UNION ALL

Line 2994: po_requisition_lines_all porl

2990: CURSOR cur_req_vend_org_details (p_req_line_id IN NUMBER )IS
2991: SELECT pov.vendor_id,
2992: porl.org_id
2993: FROM po_vendors pov,
2994: po_requisition_lines_all porl
2995: WHERE pov.vendor_name (+) = porl.suggested_vendor_name
2996: AND porl.REQUISITION_LINE_ID =p_req_line_id;
2997:
2998: -- Cursor to fetch Vendor and organization details for PO line

Line 3029: l_old_req_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;

3025:
3026: l_index NUMBER;
3027: l_count_success_rec NUMBER;
3028:
3029: l_old_req_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
3030: l_old_po_header_id PO_HEADERS_ALL.po_HEADER_ID%TYPE;
3031: l_req_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
3032: l_req_org_id PO_HEADERS_ALL.ORG_ID%TYPE;
3033: l_Po_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;