DBA Data[Home] [Help]

APPS.PAY_MX_RULES dependencies on FND_SESSIONS

Line 221: ,fnd_sessions fs

217: SELECT hl.region_1
218: FROM hr_locations_all hl
219: ,per_all_assignments_f paf
220: ,pay_assignment_actions paa
221: ,fnd_sessions fs
222: WHERE paa.assignment_action_id = cp_assignment_action_id
223: AND fs.session_id = userenv('sessionid')
224: AND paf.assignment_id = paa.assignment_id
225: AND fs.effective_date BETWEEN paf.effective_start_date