Table: HR_H2PI_US_MODIFIED_GEOCODES | Oracle EBS ETRM Search

Table: HR_H2PI_US_MODIFIED_GEOCODES 12.2.2 standalone

owner HR·PER - Human Resources·11 columns

This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to US midified geocodes while data upload is in progress.

HR.HR_H2PI_US_MODIFIED_GEOCODES·Explore PER module →

View: HR_H2PI_US_MODIFIED_GEOCODES_V 12.1.1

PER - Human Resources·8 columns

Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for US midfied geocodes

APPS.HR_H2PI_US_MODIFIED_GEOCODES_V·↳ PAY_US_MODIFIED_GEOCODES·Explore PER module →

Table: PAY_US_MODIFIED_GEOCODES 12.1.1 standalone

owner HR·PAY - Payroll·9 columns

US cities and their VERTEX geocodes, used for showing modified geocodes.

HR.PAY_US_MODIFIED_GEOCODES·Explore PAY module →

Table: PAY_US_MODIFIED_GEOCODES 12.2.2 standalone

owner HR·PAY - Payroll·10 columns

US cities and their VERTEX geocodes, used for showing modified geocodes.

HR.PAY_US_MODIFIED_GEOCODES·Explore PAY module →

View: HR_H2PI_US_MODIFIED_GEOCODES_V 12.2.2

PER - Human Resources·8 columns

Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for US midfied geocodes

APPS.HR_H2PI_US_MODIFIED_GEOCODES_V·↳ PAY_US_MODIFIED_GEOCODES·Explore PER module →

Table: HR_H2PI_US_MODIFIED_GEOCODES 12.1.1 standalone

owner HR·PER - Human Resources·11 columns

This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to US midified geocodes while data upload is in progress.

HR.HR_H2PI_US_MODIFIED_GEOCODES·Explore PER module →

VIEW: HR.PAY_US_MODIFIED_GEOCODES# 12.2.2

VIEW: HR.HR_H2PI_US_MODIFIED_GEOCODES# 12.2.2

TABLE: HR.PAY_US_MODIFIED_GEOCODES 12.2.2

owner HR

VIEW: HR.HR_H2PI_US_MODIFIED_GEOCODES# 12.2.2

owner HR

TABLE: HR.PAY_US_MODIFIED_GEOCODES 12.1.1

owner HR

TABLE: HR.HR_H2PI_US_MODIFIED_GEOCODES 12.2.2

owner HR

VIEW: HR.PAY_US_MODIFIED_GEOCODES# 12.2.2

owner HR

VIEW: APPS.HR_H2PI_US_MODIFIED_GEOCODES_V 12.1.1

VIEW: APPS.HR_H2PI_US_MODIFIED_GEOCODES_V 12.2.2

TABLE: HR.HR_H2PI_US_MODIFIED_GEOCODES 12.1.1

owner HR

APPS.PAY_US_GEOCODE_REPORT_PKG SQL Statements 12.2.2

PACKAGE BODY: APPS.PAY_US_GEOCODE_REPORT_PKG 12.1.1

used by 1

PACKAGE: APPS.PAY_US_GEOCODE_REPORT_PKG 12.1.1

used by 1

PACKAGE BODY: APPS.PAY_US_USER_CITY_UPGRADE_PKG 12.2.2

PACKAGE: APPS.PAY_US_USER_CITY_UPGRADE_PKG 12.2.2

APPS.PAY_US_PSD_UPGRADE_PKG SQL Statements 12.2.2

PACKAGE BODY: APPS.PAY_US_PSD_UPGRADE_PKG 12.2.2

APPS.PAY_US_GEOCODE_REPORT_PKG SQL Statements 12.1.1

PACKAGE: APPS.PAY_US_PSD_UPGRADE_PKG 12.2.2

APPS.HR_H2PI_VALIDATE SQL Statements 12.2.2

APPS.PAY_US_GEO_UPD_PKG SQL Statements 12.2.2

APPS.HR_H2PI_VALIDATE SQL Statements 12.1.1

PACKAGE BODY: APPS.PAY_US_GEOCODE_REPORT_PKG 12.2.2

PACKAGE BODY: APPS.PAY_US_PSD_UPGRADE_PKG 12.2.2

APPS.PAY_US_USER_CITY_UPGRADE_PKG SQL Statements 12.2.2

PACKAGE BODY: APPS.PAY_US_GEO_UPD_PKG 12.2.2

PACKAGE BODY: APPS.PAY_US_USER_CITY_UPGRADE_PKG 12.2.2

PACKAGE BODY: APPS.HR_H2PI_VALIDATE 12.2.2

PACKAGE BODY: APPS.HR_H2PI_VALIDATE 12.1.1

PACKAGE BODY: APPS.PAY_US_GEOCODE_REPORT_PKG 12.1.1

eTRM - PAY Tables and Views 12.1.1

Temporary table used to hold invalid location addresses.

eTRM - PAY Tables and Views 12.2.2

Temporary table used to hold invalid location addresses.

eTRM - PER Tables and Views 12.2.2

Table to store NQF Training info for a person

eTRM - PER Tables and Views 12.1.1

Table to store NQF Training info for a person

eTRM - PAY Tables and Views 12.2.2

Temporary table used to hold invalid location addresses.

eTRM - PAY Tables and Views 12.1.1

Temporary table used to hold invalid location addresses.

eTRM - PER Tables and Views 12.2.2

Table to store NQF Training info for a person

eTRM - PER Tables and Views 12.1.1

Table to store NQF Training info for a person

Results for “old_city_code”