APPS.HR_RU_ADDRESS_HOOK dependencies on PER_ADDRESSES

Line 40: l_add_information13 per_addresses.add_information13%TYPE;

36: p_postal_code IN VARCHAR2
37: )
38: AS
39: l_proc CONSTANT VARCHAR2 (72) := g_package || 'UPDATE_RU_ADDRESS';
40: l_add_information13 per_addresses.add_information13%TYPE;
41: l_postal_code per_addresses.postal_code%TYPE;
42:
43: CURSOR csr_get_address_details (p_id NUMBER)
44: IS

Line 41: l_postal_code per_addresses.postal_code%TYPE;

37: )
38: AS
39: l_proc CONSTANT VARCHAR2 (72) := g_package || 'UPDATE_RU_ADDRESS';
40: l_add_information13 per_addresses.add_information13%TYPE;
41: l_postal_code per_addresses.postal_code%TYPE;
42:
43: CURSOR csr_get_address_details (p_id NUMBER)
44: IS
45: SELECT style, add_information13, postal_code

Line 46: FROM per_addresses

42:
43: CURSOR csr_get_address_details (p_id NUMBER)
44: IS
45: SELECT style, add_information13, postal_code
46: FROM per_addresses
47: WHERE address_id = p_id;
48:
49: l_address_record csr_get_address_details%ROWTYPE;
50: BEGIN

Line 100: l_add_information13 per_addresses.add_information13%TYPE;

96: p_postal_code IN VARCHAR2
97: )
98: AS
99: l_proc CONSTANT VARCHAR2 (72) := g_package || 'UPDATE_RU_ADDRESS_WITH_STYLE';
100: l_add_information13 per_addresses.add_information13%TYPE;
101: l_postal_code per_addresses.postal_code%TYPE;
102:
103: CURSOR csr_get_address_details (p_id NUMBER)
104: IS

Line 101: l_postal_code per_addresses.postal_code%TYPE;

97: )
98: AS
99: l_proc CONSTANT VARCHAR2 (72) := g_package || 'UPDATE_RU_ADDRESS_WITH_STYLE';
100: l_add_information13 per_addresses.add_information13%TYPE;
101: l_postal_code per_addresses.postal_code%TYPE;
102:
103: CURSOR csr_get_address_details (p_id NUMBER)
104: IS
105: SELECT add_information13, postal_code

Line 106: FROM per_addresses

102:
103: CURSOR csr_get_address_details (p_id NUMBER)
104: IS
105: SELECT add_information13, postal_code
106: FROM per_addresses
107: WHERE address_id = p_id;
108:
109: l_address_record csr_get_address_details%ROWTYPE;
110: BEGIN