APPS.PAY_NO_RULES dependencies on FND_SESSIONS

Line 129: ,fnd_sessions fs

125: ,pay_input_values_f iv1
126: ,pay_element_entries_f ee
127: ,pay_element_entry_values_f eev1
128: ,pay_assignment_actions pac
129: ,fnd_sessions fs
130: ,pay_input_values_f_tl ivtl
131: WHERE per.person_id = asg1.person_id
132: AND asg2.person_id = per.person_id
133: AND asg2.primary_flag = 'Y'

Line 176: ,fnd_sessions fs

172: ,pay_input_values_f iv1
173: ,pay_element_entries_f ee
174: ,pay_element_entry_values_f eev1
175: ,pay_assignment_actions pac
176: ,fnd_sessions fs
177: ,pay_input_values_f_tl ivtl
178: WHERE per.person_id = asg1.person_id
179: AND asg2.person_id = per.person_id
180: AND asg2.primary_flag = 'Y'

Line 225: ,fnd_sessions fs

221: ,pay_input_values_f iv1
222: ,pay_element_entries_f ee
223: ,pay_element_entry_values_f eev1
224: ,pay_assignment_actions pac
225: ,fnd_sessions fs
226: ,pay_input_values_f_tl ivtl
227: WHERE per.person_id = asg1.person_id
228: AND asg2.person_id = per.person_id
229: AND asg2.primary_flag = 'Y'

Line 271: ,fnd_sessions fs

267: ,pay_input_values_f iv1
268: ,pay_element_entries_f ee
269: ,pay_element_entry_values_f eev1
270: ,pay_assignment_actions pac
271: ,fnd_sessions fs
272: ,pay_input_values_f_tl ivtl
273: WHERE per.person_id = asg1.person_id
274: AND asg2.person_id = per.person_id
275: AND asg2.primary_flag = 'Y'

Line 1353: fnd_sessions fs

1349: cursor csr_ssb_codes is
1350: select row_low_range_or_name
1351: from pay_user_tables put,
1352: pay_user_rows_f pur,
1353: fnd_sessions fs
1354: where
1355: put.user_table_name ='NO_SSB_CODE_RULES'
1356: and put.user_table_id = pur.user_table_id
1357: and fs.session_id = userenv('sessionid')