APPS.HR_AE_VALIDATE_PKG dependencies on PER_ADDRESSES

Line 1047: FROM per_addresses

1043: ,p_region_1 IN VARCHAR2) IS
1044:
1045: CURSOR csr_get_style(l_address_id number) is
1046: SELECT style,person_id
1047: FROM per_addresses
1048: WHERE address_id = l_address_id;
1049:
1050: CURSOR csr_fetch_bus_id IS
1051: SELECT distinct pad.business_group_id

Line 1052: FROM per_addresses pad,

1048: WHERE address_id = l_address_id;
1049:
1050: CURSOR csr_fetch_bus_id IS
1051: SELECT distinct pad.business_group_id
1052: FROM per_addresses pad,
1053: hr_organization_information hoi
1054: WHERE pad.ADDRESS_ID = p_address_id
1055: AND pad.business_group_id = hoi.organization_id;
1056:

Line 1059: l_style per_addresses.style%TYPE;

1055: AND pad.business_group_id = hoi.organization_id;
1056:
1057: l_bg_id number;
1058:
1059: l_style per_addresses.style%TYPE;
1060: l_person_id per_addresses.person_id%TYPE;
1061: --
1062: BEGIN
1063:

Line 1060: l_person_id per_addresses.person_id%TYPE;

1056:
1057: l_bg_id number;
1058:
1059: l_style per_addresses.style%TYPE;
1060: l_person_id per_addresses.person_id%TYPE;
1061: --
1062: BEGIN
1063:
1064: /* Added for GSI Bug 5472781 */