APPS.PAY_IN_TAX_UTILS dependencies on PER_ADDRESSES

Line 212: /*Bug:3907894 Added the date effective check on per_addresses table */

208: --------------------------------------------------------------------------
209: FUNCTION get_metro_status (p_assignment_id in number,
210: p_effective_date in date)
211: return Varchar2 is
212: /*Bug:3907894 Added the date effective check on per_addresses table */
213: cursor c_metro_status
214: is
215: select pad.add_information16
216: from per_addresses pad,

Line 216: from per_addresses pad,

212: /*Bug:3907894 Added the date effective check on per_addresses table */
213: cursor c_metro_status
214: is
215: select pad.add_information16
216: from per_addresses pad,
217: per_all_assignments_f paa
218: where paa.assignment_id = p_assignment_id
219: and pad.person_id = paa.person_id
220: and pad.primary_flag = 'Y'