APPS.IGW_GR_PERSONNEL dependencies on HZ_PARTIES

Line 92: l_address1 hz_parties.address1%TYPE;

88: END POPULATE_BIO_TABLES;
89:
90: ------------------------------------------------------------
91: FUNCTION GET_FORMATTED_ADDRESS (P_PARTY_ID NUMBER) RETURN VARCHAR2 is
92: l_address1 hz_parties.address1%TYPE;
93: l_address2 hz_parties.address2%TYPE;
94: l_address3 hz_parties.address3%TYPE;
95: l_address4 hz_parties.address4%TYPE;
96: l_city hz_parties.city%TYPE;

Line 93: l_address2 hz_parties.address2%TYPE;

89:
90: ------------------------------------------------------------
91: FUNCTION GET_FORMATTED_ADDRESS (P_PARTY_ID NUMBER) RETURN VARCHAR2 is
92: l_address1 hz_parties.address1%TYPE;
93: l_address2 hz_parties.address2%TYPE;
94: l_address3 hz_parties.address3%TYPE;
95: l_address4 hz_parties.address4%TYPE;
96: l_city hz_parties.city%TYPE;
97: l_state hz_parties.state%TYPE;

Line 94: l_address3 hz_parties.address3%TYPE;

90: ------------------------------------------------------------
91: FUNCTION GET_FORMATTED_ADDRESS (P_PARTY_ID NUMBER) RETURN VARCHAR2 is
92: l_address1 hz_parties.address1%TYPE;
93: l_address2 hz_parties.address2%TYPE;
94: l_address3 hz_parties.address3%TYPE;
95: l_address4 hz_parties.address4%TYPE;
96: l_city hz_parties.city%TYPE;
97: l_state hz_parties.state%TYPE;
98: l_postal_code hz_parties.postal_code%TYPE;

Line 95: l_address4 hz_parties.address4%TYPE;

91: FUNCTION GET_FORMATTED_ADDRESS (P_PARTY_ID NUMBER) RETURN VARCHAR2 is
92: l_address1 hz_parties.address1%TYPE;
93: l_address2 hz_parties.address2%TYPE;
94: l_address3 hz_parties.address3%TYPE;
95: l_address4 hz_parties.address4%TYPE;
96: l_city hz_parties.city%TYPE;
97: l_state hz_parties.state%TYPE;
98: l_postal_code hz_parties.postal_code%TYPE;
99: l_address varchar2(1000) := null;

Line 96: l_city hz_parties.city%TYPE;

92: l_address1 hz_parties.address1%TYPE;
93: l_address2 hz_parties.address2%TYPE;
94: l_address3 hz_parties.address3%TYPE;
95: l_address4 hz_parties.address4%TYPE;
96: l_city hz_parties.city%TYPE;
97: l_state hz_parties.state%TYPE;
98: l_postal_code hz_parties.postal_code%TYPE;
99: l_address varchar2(1000) := null;
100:

Line 97: l_state hz_parties.state%TYPE;

93: l_address2 hz_parties.address2%TYPE;
94: l_address3 hz_parties.address3%TYPE;
95: l_address4 hz_parties.address4%TYPE;
96: l_city hz_parties.city%TYPE;
97: l_state hz_parties.state%TYPE;
98: l_postal_code hz_parties.postal_code%TYPE;
99: l_address varchar2(1000) := null;
100:
101: BEGIN

Line 98: l_postal_code hz_parties.postal_code%TYPE;

94: l_address3 hz_parties.address3%TYPE;
95: l_address4 hz_parties.address4%TYPE;
96: l_city hz_parties.city%TYPE;
97: l_state hz_parties.state%TYPE;
98: l_postal_code hz_parties.postal_code%TYPE;
99: l_address varchar2(1000) := null;
100:
101: BEGIN
102: