APPS.PER_ES_ADDRESS dependencies on PER_ADDRESSES

Line 53: FROM per_addresses

49: ,p_region_2 IN VARCHAR2) IS
50: --
51: CURSOR csr_get_address_info(c_address_id number) is
52: SELECT style, postal_code, region_2
53: FROM per_addresses
54: WHERE address_id=c_address_id;
55: --
56: l_rec csr_get_address_info%ROWTYPE;
57: l_postal_code per_addresses.postal_code%TYPE;

Line 57: l_postal_code per_addresses.postal_code%TYPE;

53: FROM per_addresses
54: WHERE address_id=c_address_id;
55: --
56: l_rec csr_get_address_info%ROWTYPE;
57: l_postal_code per_addresses.postal_code%TYPE;
58: l_region_2 per_addresses.region_2%TYPE;
59:
60:
61: BEGIN

Line 58: l_region_2 per_addresses.region_2%TYPE;

54: WHERE address_id=c_address_id;
55: --
56: l_rec csr_get_address_info%ROWTYPE;
57: l_postal_code per_addresses.postal_code%TYPE;
58: l_region_2 per_addresses.region_2%TYPE;
59:
60:
61: BEGIN
62: --

Line 102: FROM per_addresses

98: ,p_style IN VARCHAR2) IS
99: --
100: CURSOR csr_get_address_info(c_address_id number) is
101: SELECT postal_code, region_2
102: FROM per_addresses
103: WHERE address_id=c_address_id;
104: --
105: l_rec csr_get_address_info%ROWTYPE;
106: l_postal_code per_addresses.postal_code%TYPE;

Line 106: l_postal_code per_addresses.postal_code%TYPE;

102: FROM per_addresses
103: WHERE address_id=c_address_id;
104: --
105: l_rec csr_get_address_info%ROWTYPE;
106: l_postal_code per_addresses.postal_code%TYPE;
107: l_region_2 per_addresses.region_2%TYPE;
108: --
109: BEGIN
110: --

Line 107: l_region_2 per_addresses.region_2%TYPE;

103: WHERE address_id=c_address_id;
104: --
105: l_rec csr_get_address_info%ROWTYPE;
106: l_postal_code per_addresses.postal_code%TYPE;
107: l_region_2 per_addresses.region_2%TYPE;
108: --
109: BEGIN
110: --
111: -- Added for GSI Bug 5472781