APPS.PAY_IN_EOY_REPORTS dependencies on HR_GENERAL

Line 243: , hr_general.decode_lookup('IN_STATES',hr_loc.loc_information16)

239: , hr_loc.address_line_2
240: , hr_loc.address_line_3
241: , hr_loc.loc_information14
242: , hr_loc.loc_information15
243: , hr_general.decode_lookup('IN_STATES',hr_loc.loc_information16)
244: , hr_general.decode_lookup('PER_US_COUNTRY_CODE',hr_loc.country)
245: , hr_loc.postal_code
246: , hr_loc.loc_information16
247: FROM hr_locations hr_loc

Line 244: , hr_general.decode_lookup('PER_US_COUNTRY_CODE',hr_loc.country)

240: , hr_loc.address_line_3
241: , hr_loc.loc_information14
242: , hr_loc.loc_information15
243: , hr_general.decode_lookup('IN_STATES',hr_loc.loc_information16)
244: , hr_general.decode_lookup('PER_US_COUNTRY_CODE',hr_loc.country)
245: , hr_loc.postal_code
246: , hr_loc.loc_information16
247: FROM hr_locations hr_loc
248: WHERE location_id = p_location_id;

Line 360: , hr_general.decode_lookup('IN_STATES',pad.add_information15)

356: , pad.address_line2
357: , pad.address_line3
358: , pad.add_information13
359: , pad.add_information14
360: , hr_general.decode_lookup('IN_STATES',pad.add_information15)
361: , hr_general.decode_lookup('PER_US_COUNTRY_CODE',pad.country)
362: , pad.postal_code
363: FROM per_addresses pad
364: WHERE pad.address_id = p_address_id;

Line 361: , hr_general.decode_lookup('PER_US_COUNTRY_CODE',pad.country)

357: , pad.address_line3
358: , pad.add_information13
359: , pad.add_information14
360: , hr_general.decode_lookup('IN_STATES',pad.add_information15)
361: , hr_general.decode_lookup('PER_US_COUNTRY_CODE',pad.country)
362: , pad.postal_code
363: FROM per_addresses pad
364: WHERE pad.address_id = p_address_id;
365: