APPS.PAY_IN_TAX_UTILS dependencies on PER_ADDRESSES

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

83: --------------------------------------------------------------------------
84: FUNCTION get_metro_status (p_assignment_id in number,
85: p_effective_date in date)
86: return Varchar2 is
87: /*Bug:3907894 Added the date effective check on per_addresses table */
88: cursor c_metro_status
89: is
90: select pad.add_information16
91: from per_addresses pad,

Line 91: from per_addresses pad,

87: /*Bug:3907894 Added the date effective check on per_addresses table */
88: cursor c_metro_status
89: is
90: select pad.add_information16
91: from per_addresses pad,
92: per_all_assignments_f paa
93: where paa.assignment_id = p_assignment_id
94: and pad.person_id = paa.person_id
95: and pad.primary_flag = 'Y'