APPS.ZX_MIGRATE_REP_ENTITIES_PKG dependencies on HR_LOCATIONS

Line 2883: hr_locations loc

2879: FROM
2880: AR_VAT_TAX_ALL_B codes,
2881: ZX_RATES_B rates,
2882: ZX_REPORTING_CODES_B report_codes,
2883: hr_locations loc
2884: WHERE
2885: codes.global_attribute_category = 'JA.KR.ARXSUVAT.VAT'
2886: AND codes.vat_tax_id = rates.tax_rate_id
2887: and loc.location_id = codes.global_attribute1

Line 3962: from ap_tax_codes_all aptax, hr_locations hrloc

3958: (SELECT min(r.effective_from) FROM zx_rates_b r WHERE r.tax_regime_code = zxrb.tax_regime_code) l_start_date
3959: from
3960: (
3961: select tax_id,hrloc.location_code location_code
3962: from ap_tax_codes_all aptax, hr_locations hrloc
3963: where aptax.global_attribute_category = 'JA.KR.APXTADTC.WITHHOLDING'
3964: and aptax.global_attribute1 = to_char(hrloc.location_id)
3965: ) tax_id_values_and_codes,
3966: zx_rates_b zxrb

Line 4032: HR_LOCATIONS hrloc,

4028: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
4029: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
4030: FROM
4031: AP_TAX_CODES_ALL codes,
4032: HR_LOCATIONS hrloc,
4033: ZX_RATES_B rates,
4034: ZX_REPORTING_TYPES_B reporting_types,
4035: ZX_REPORTING_CODES_B report_codes
4036: WHERE

Line 5499: hr_locations locations

5495: types.reporting_type_id reporting_type_id,
5496: types.effective_from effective_from
5497: FROM
5498: zx_reporting_types_b types,
5499: hr_locations locations
5500: WHERE
5501: types.reporting_type_code = 'KR_LOCATION'
5502: AND types.record_type_code = 'MIGRATED'
5503: AND locations.global_attribute_category = 'JA.KR.PERWSLOC.WITHHOLDING'

Line 5510: from hr_locations

5506: AND (NOT EXISTS (select 1 from zx_reporting_codes_b
5507: where reporting_type_id = types.reporting_type_id
5508: and reporting_code_char_value = locations.location_code
5509: /*(select location_code
5510: from hr_locations
5511: where global_attribute_category = 'JA.KR.PERWSLOC.WITHHOLDING'
5512: and global_attribute1 is not null)*/
5513: )
5514: )

Line 5696: from ar_vat_tax_all_b artax, hr_locations hrloc

5692: (SELECT min(r.effective_from) FROM zx_rates_b r WHERE r.tax_regime_code = zxrb.tax_regime_code) l_start_date
5693: from
5694: (
5695: select vat_tax_id,hrloc.location_code location_code
5696: from ar_vat_tax_all_b artax, hr_locations hrloc
5697: where artax.global_attribute_category = 'JA.KR.ARXSUVAT.VAT' -- Bug 5031787
5698: and artax.global_attribute1 = to_char(hrloc.location_id)
5699: ) tax_id_values_and_codes,
5700: zx_rates_b zxrb

Line 5765: HR_LOCATIONS hrloc,

5761: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
5762: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
5763: FROM
5764: AR_VAT_TAX_ALL_B codes,
5765: HR_LOCATIONS hrloc,
5766: ZX_RATES_B rates,
5767: ZX_REPORTING_TYPES_B reporting_types,
5768: ZX_REPORTING_CODES_B report_codes
5769: WHERE

Line 5847: | 2.Hr Locations |

5843: | |
5844: | Used to create the reporting type associations |
5845: | for various entities like |
5846: | 1.HR Organization Information |
5847: | 2.Hr Locations |
5848: | 3.AR System Parameters All |
5849: | 4.Financial Systems Parameters All |
5850: | |
5851: | SCOPE - PUBLIC |