APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on JAI_PO_LINE_LOCATIONS

Line 1097: lv_service_type_code jai_po_line_locations.service_type_code%TYPE;

1093: exchange_rate_type
1094: FROM ap_invoices_all
1095: WHERE invoice_id = cp_invoice_id ;
1096:
1097: lv_service_type_code jai_po_line_locations.service_type_code%TYPE;
1098: ln_organization_id NUMBER;
1099: ln_location_id NUMBER;
1100: lv_process_flag VARCHAR2(15);
1101: lv_process_message VARCHAR2(4000);

Line 1919: jai_po_line_locations jpll

1915: FROM ap_invoice_distributions_all
1916: WHERE po_distribution_id IN ( SELECT pda.po_distribution_id
1917: FROM po_line_locations_all pll,
1918: po_distributions_all pda,
1919: jai_po_line_locations jpll
1920: WHERE pll.line_location_id = jpll.line_location_id
1921: AND pll.line_location_id = pda.line_location_id
1922: AND pll.ship_to_organization_id = p_organization_id
1923: )

Line 2214: jai_po_line_locations jpll

2210: AND po_distribution_id in
2211: (SELECT pda.po_distribution_id
2212: FROM po_line_locations_all pll,
2213: po_distributions_all pda,
2214: jai_po_line_locations jpll
2215: WHERE pll.line_location_id = jpll.line_location_id
2216: AND pll.line_location_id = pda.line_location_id
2217: AND pll.ship_to_organization_id = p_organization_id
2218: )