DBA Data[Home] [Help]

APPS.PAY_IN_SOE dependencies on HR_GENERAL

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

325: , pad.address_line2
326: , pad.address_line3
327: , pad.add_information13
328: , pad.add_information14
329: , hr_general.decode_lookup('IN_STATES',pad.add_information15)
330: , hr_general.decode_lookup('PER_US_COUNTRY_CODE',pad.country)
331: , pad.postal_code
332: FROM per_addresses pad
333: WHERE pad.address_id = p_address_id;

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

326: , pad.address_line3
327: , pad.add_information13
328: , pad.add_information14
329: , hr_general.decode_lookup('IN_STATES',pad.add_information15)
330: , hr_general.decode_lookup('PER_US_COUNTRY_CODE',pad.country)
331: , pad.postal_code
332: FROM per_addresses pad
333: WHERE pad.address_id = p_address_id;
334: