DBA Data[Home] [Help]

APPS.ZX_JA_EXTRACT_PKG dependencies on HR_LOCATIONS

Line 1184: hr_locations loc,

1180: -- l_ind_classif_tbl,
1181: l_detail_tax_line_id_tbl
1182: FROM zx_reporting_types_b rep_type,
1183: zx_report_codes_assoc rep_ass,
1184: hr_locations loc,
1185: zx_rep_trx_detail_t dtl
1186: WHERE rep_type.reporting_type_code = 'KR_BUSINESS_LOCATIONS'
1187: AND rep_ass.reporting_type_id = rep_type.reporting_type_id
1188: AND rep_ass.entity_code = 'ZX_RATES'

Line 1876: hr_locations loc,

1872: -- l_ind_classif_tbl,
1873: l_detail_tax_line_id_tbl
1874: FROM zx_reporting_types_b rep_type,
1875: zx_report_codes_assoc rep_ass,
1876: hr_locations loc,
1877: zx_rep_trx_detail_t dtl
1878: WHERE rep_type.reporting_type_code = 'KR_BUSINESS_LOCATIONS'
1879: AND rep_ass.reporting_type_id = rep_type.reporting_type_id
1880: AND rep_ass.entity_code = 'ZX_RATES'

Line 2663: hr_locations loc,

2659: sysdate,
2660: fnd_global.login_id
2661: FROM hr_all_organization_units ou,
2662: hr_organization_information oi,
2663: hr_locations loc,
2664: gl_sets_of_books sob,
2665: zx_rep_trx_detail_t dtl
2666: WHERE ou.organization_id = oi.organization_id
2667: AND ou.location_id = loc.location_id