APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on HR_LOCATIONS

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

143: select name
144: from hr_organization_units
145: where organization_id = cp_organization_id;
146:
147: cursor c_get_location_name (cp_location_id hr_locations_all.location_id%type)
148: is
149: select description
150: from hr_locations_all
151: where location_id = cp_location_id;

Line 150: from hr_locations_all

146:
147: cursor c_get_location_name (cp_location_id hr_locations_all.location_id%type)
148: is
149: select description
150: from hr_locations_all
151: where location_id = cp_location_id;
152:
153:
154:

Line 264: lv_location_name hr_locations_all.description%type;

260: lv_service_type_code jai_rgm_trx_records.service_type_code%type;
261:
262: lr_trx_repo_extract jai_trx_repo_extract_gt%rowtype;
263: lv_organization_name hr_organization_units.name%type;
264: lv_location_name hr_locations_all.description%type;
265: ln_reg_id number;
266:
267: begin
268:

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

784: , po_lines_all pol
785: , po_line_locations_all poll /*6843479*/
786: , mtl_system_items msi
787: , po_vendors pov
788: , hr_locations hl /* Added by vkantamn for Bug#6083978 */
789: -- , financials_system_parameters fsp /* Commented by vkantamn for Bug#6083978 */
790: where
791: --poh.po_header_id = p_document_id /* Commented by vkantamn for Bug#6083978 */
792: poh.po_header_id = cp_header_id /* Added by vkantamn for Bug#6083978 */