APPS.PAY_CA_RL2_MAG dependencies on FND_SESSIONS

Line 1271: (select lookup_code from hr_lookups hl, fnd_sessions fs

1267: pay_ca_eoy_rl2_trans_info_v tran
1268: WHERE emp.assignment_action_id = p_asg_action_id
1269: AND emp.payroll_action_id = tran.payroll_action_id
1270: AND nvl(emp.rl2_source_of_income,1) not in --6525968
1271: (select lookup_code from hr_lookups hl, fnd_sessions fs
1272: where fs.session_id = USERENV('SESSIONID')
1273: and hl.lookup_type = 'PAY_CA_RL2_SOURCE_OF_INCOME'
1274: and (fs.effective_date > nvl(hl.end_date_active,to_date('31/12/4712','dd/mm/yyyy'))
1275: or hl.enabled_flag='N')