APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on HR_LOCATIONS

Line 561: cursor c_get_location_name (cp_location_id hr_locations_all.location_id%type)

557: select name
558: from hr_organization_units
559: where organization_id = cp_organization_id;
560:
561: cursor c_get_location_name (cp_location_id hr_locations_all.location_id%type)
562: is
563: select description
564: from hr_locations_all
565: where location_id = cp_location_id;

Line 564: from hr_locations_all

560:
561: cursor c_get_location_name (cp_location_id hr_locations_all.location_id%type)
562: is
563: select description
564: from hr_locations_all
565: where location_id = cp_location_id;
566:
567:
568:

Line 678: lv_location_name hr_locations_all.description%type;

674: lv_service_type_code jai_rgm_trx_records.service_type_code%type;
675:
676: lr_trx_repo_extract jai_trx_repo_extract_gt%rowtype;
677: lv_organization_name hr_organization_units.name%type;
678: lv_location_name hr_locations_all.description%type;
679: ln_reg_id number;
680: --start additions for bug#10085619
681: cursor c_get_line_number(p_invoice_id jai_rgm_trx_refs.invoice_id%type,p_line_id jai_rgm_trx_refs.line_id%type)
682: is

Line 1444: , hr_locations hl /* Added by vkantamn for Bug#6083978 */

1440: , po_lines_all pol
1441: , po_line_locations_all poll /*6841116*/
1442: , mtl_system_items msi
1443: , po_vendors pov
1444: , hr_locations hl /* Added by vkantamn for Bug#6083978 */
1445: -- , financials_system_parameters fsp /* Commented by vkantamn for Bug#6083978 */
1446: where
1447: --poh.po_header_id = p_document_id /* Commented by vkantamn for Bug#6083978 */
1448: poh.po_header_id = cp_header_id /* Added by vkantamn for Bug#6083978 */

Line 1484: , hr_locations_all hl

1480: , rcv_shipment_lines rsl
1481: , po_lines_all pla
1482: , mtl_system_items msi
1483: , po_vendors pov
1484: , hr_locations_all hl
1485: where
1486: rta.transaction_id = cp_transaction_id
1487: and rta.po_line_id = pla.po_line_id
1488: and rta.shipment_header_id = rsh.shipment_header_id