eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_AE_VALIDATE_PKG dependencies on PER_ADDRESSES

Line 1023: FROM per_addresses

1019: ,p_region_1 IN VARCHAR2) IS
1020:
1021: CURSOR csr_get_style(l_address_id number) is
1022: SELECT style,person_id
1023: FROM per_addresses
1024: WHERE address_id = l_address_id;
1025: l_style per_addresses.style%TYPE;
1026: l_person_id per_addresses.person_id%TYPE;
1027: --

Line 1025: l_style per_addresses.style%TYPE;

1021: CURSOR csr_get_style(l_address_id number) is
1022: SELECT style,person_id
1023: FROM per_addresses
1024: WHERE address_id = l_address_id;
1025: l_style per_addresses.style%TYPE;
1026: l_person_id per_addresses.person_id%TYPE;
1027: --
1028: BEGIN
1029:

Line 1026: l_person_id per_addresses.person_id%TYPE;

1022: SELECT style,person_id
1023: FROM per_addresses
1024: WHERE address_id = l_address_id;
1025: l_style per_addresses.style%TYPE;
1026: l_person_id per_addresses.person_id%TYPE;
1027: --
1028: BEGIN
1029:
1030: /* Added for GSI Bug 5472781 */