APPS.ZX_JA_EXTRACT_PKG dependencies on HR_LOCATIONS

Line 1189: hr_locations loc,

1185: -- l_ind_classif_tbl,
1186: l_detail_tax_line_id_tbl
1187: FROM zx_reporting_types_b rep_type,
1188: zx_report_codes_assoc rep_ass,
1189: hr_locations loc,
1190: zx_rep_trx_detail_t dtl
1191: WHERE rep_type.reporting_type_code = 'KR_BUSINESS_LOCATIONS'
1192: AND rep_ass.reporting_type_id = rep_type.reporting_type_id
1193: AND rep_ass.entity_code = 'ZX_RATES'

Line 1949: hr_locations loc,

1945: -- l_ind_classif_tbl,
1946: l_detail_tax_line_id_tbl
1947: FROM zx_reporting_types_b rep_type,
1948: zx_report_codes_assoc rep_ass,
1949: hr_locations loc,
1950: zx_rep_trx_detail_t dtl
1951: WHERE rep_type.reporting_type_code = 'KR_BUSINESS_LOCATIONS'
1952: AND rep_ass.reporting_type_id = rep_type.reporting_type_id
1953: AND rep_ass.entity_code = 'ZX_RATES'

Line 2740: hr_locations loc,

2736: fnd_global.login_id,
2737: p_trl_global_variables_rec.request_id
2738: FROM hr_all_organization_units ou,
2739: hr_organization_information oi,
2740: hr_locations loc,
2741: gl_sets_of_books sob,
2742: zx_rep_trx_detail_t dtl
2743: WHERE ou.organization_id = oi.organization_id
2744: AND ou.location_id = loc.location_id