APPS.ZX_MIGRATE_REP_ENTITIES_PKG dependencies on HR_LOCATIONS

Line 2910: hr_locations loc

2906: FROM
2907: AR_VAT_TAX_ALL_B codes,
2908: ZX_RATES_B rates,
2909: ZX_REPORTING_CODES_B report_codes,
2910: hr_locations loc
2911: WHERE
2912: codes.global_attribute_category = 'JA.KR.ARXSUVAT.VAT'
2913: AND codes.vat_tax_id = rates.tax_rate_id
2914: and loc.location_id = codes.global_attribute1

Line 3989: from ap_tax_codes_all aptax, hr_locations hrloc

3985: (SELECT min(r.effective_from) FROM zx_rates_b r WHERE r.tax_regime_code = zxrb.tax_regime_code) l_start_date
3986: from
3987: (
3988: select tax_id,hrloc.location_code location_code
3989: from ap_tax_codes_all aptax, hr_locations hrloc
3990: where aptax.global_attribute_category = 'JA.KR.APXTADTC.WITHHOLDING'
3991: and aptax.global_attribute1 = to_char(hrloc.location_id)
3992: ) tax_id_values_and_codes,
3993: zx_rates_b zxrb

Line 4059: HR_LOCATIONS hrloc,

4055: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
4056: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
4057: FROM
4058: AP_TAX_CODES_ALL codes,
4059: HR_LOCATIONS hrloc,
4060: ZX_RATES_B rates,
4061: ZX_REPORTING_TYPES_B reporting_types,
4062: ZX_REPORTING_CODES_B report_codes
4063: WHERE

Line 5528: hr_locations locations

5524: types.reporting_type_id reporting_type_id,
5525: types.effective_from effective_from
5526: FROM
5527: zx_reporting_types_b types,
5528: hr_locations locations
5529: WHERE
5530: types.reporting_type_code = 'KR_LOCATION'
5531: AND types.record_type_code = 'MIGRATED'
5532: AND locations.global_attribute_category = 'JA.KR.PERWSLOC.WITHHOLDING'

Line 5539: from hr_locations

5535: AND (NOT EXISTS (select 1 from zx_reporting_codes_b
5536: where reporting_type_id = types.reporting_type_id
5537: and reporting_code_char_value = locations.location_code
5538: /*(select location_code
5539: from hr_locations
5540: where global_attribute_category = 'JA.KR.PERWSLOC.WITHHOLDING'
5541: and global_attribute1 is not null)*/
5542: )
5543: )

Line 5725: from ar_vat_tax_all_b artax, hr_locations hrloc

5721: (SELECT min(r.effective_from) FROM zx_rates_b r WHERE r.tax_regime_code = zxrb.tax_regime_code) l_start_date
5722: from
5723: (
5724: select vat_tax_id,hrloc.location_code location_code
5725: from ar_vat_tax_all_b artax, hr_locations hrloc
5726: where artax.global_attribute_category = 'JA.KR.ARXSUVAT.VAT' -- Bug 5031787
5727: and artax.global_attribute1 = to_char(hrloc.location_id)
5728: ) tax_id_values_and_codes,
5729: zx_rates_b zxrb

Line 5794: HR_LOCATIONS hrloc,

5790: report_codes.REPORTING_CODE_DATE_VALUE REPORTING_CODE_DATE_VALUE,
5791: report_codes.REPORTING_CODE_NUM_VALUE REPORTING_CODE_NUM_VALUE
5792: FROM
5793: AR_VAT_TAX_ALL_B codes,
5794: HR_LOCATIONS hrloc,
5795: ZX_RATES_B rates,
5796: ZX_REPORTING_TYPES_B reporting_types,
5797: ZX_REPORTING_CODES_B report_codes
5798: WHERE

Line 5876: | 2.Hr Locations |

5872: | |
5873: | Used to create the reporting type associations |
5874: | for various entities like |
5875: | 1.HR Organization Information |
5876: | 2.Hr Locations |
5877: | 3.AR System Parameters All |
5878: | 4.Financial Systems Parameters All |
5879: | |
5880: | SCOPE - PUBLIC |