APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on JAI_PO_LINE_LOCATIONS

Line 283: lv_service_type_code jai_po_line_locations.service_type_code%TYPE;

279: SELECT b.ship_to_organization_id
280: FROM po_distributions_all a, po_line_locations_all b
281: WHERE a.line_location_id = b.line_location_id
282: AND a.po_distribution_id = cp_po_distribution_id;*/
283: lv_service_type_code jai_po_line_locations.service_type_code%TYPE;
284: ln_organization_id NUMBER;
285: ln_location_id NUMBER;
286: lv_process_flag VARCHAR2(15);
287: lv_process_message VARCHAR2(4000);

Line 910: jai_po_line_locations jpll

906: FROM ap_invoice_distributions_all
907: WHERE po_distribution_id IN ( SELECT pda.po_distribution_id
908: FROM po_line_locations_all pll,
909: po_distributions_all pda,
910: jai_po_line_locations jpll
911: WHERE pll.line_location_id = jpll.line_location_id
912: AND pll.line_location_id = pda.line_location_id
913: AND pll.ship_to_organization_id = p_organization_id
914: )

Line 1050: jai_po_line_locations jpll

1046: AND po_distribution_id in
1047: (SELECT pda.po_distribution_id
1048: FROM po_line_locations_all pll,
1049: po_distributions_all pda,
1050: jai_po_line_locations jpll
1051: WHERE pll.line_location_id = jpll.line_location_id
1052: AND pll.line_location_id = pda.line_location_id
1053: AND pll.ship_to_organization_id = p_organization_id
1054: )