[Home] [Help]
112: -- bug#8752864 fix starts
113: SELECT petf.element_name
114: FROM pay_element_types_f petf
115: , pay_element_entries_f pee
116: , fnd_sessions fs
117: WHERE pee.element_entry_id = p_ee_id
118: AND pee.element_type_id = petf.element_type_id
119: AND fs.session_id = USERENV('sessionid')
120: AND fs.effective_date BETWEEN petf.effective_start_date AND petf.effective_end_date
131: ,pay_input_values_f iv1
132: ,pay_element_entries_f ee
133: ,pay_element_entry_values_f eev1
134: ,pay_assignment_actions pac
135: ,fnd_sessions fs
136: ,pay_input_values_f_tl ivtl
137: WHERE per.person_id = asg1.person_id
138: AND asg2.person_id = per.person_id
139: AND asg2.primary_flag = 'Y'
178: ,pay_input_values_f iv1
179: ,pay_element_entries_f ee
180: ,pay_element_entry_values_f eev1
181: ,pay_assignment_actions pac
182: ,fnd_sessions fs
183: ,pay_input_values_f_tl ivtl
184: WHERE per.person_id = asg1.person_id
185: AND asg2.person_id = per.person_id
186: AND asg2.primary_flag = 'Y'
227: ,pay_input_values_f iv1
228: ,pay_element_entries_f ee
229: ,pay_element_entry_values_f eev1
230: ,pay_assignment_actions pac
231: ,fnd_sessions fs
232: ,pay_input_values_f_tl ivtl
233: WHERE per.person_id = asg1.person_id
234: AND asg2.person_id = per.person_id
235: AND asg2.primary_flag = 'Y'
273: ,pay_input_values_f iv1
274: ,pay_element_entries_f ee
275: ,pay_element_entry_values_f eev1
276: ,pay_assignment_actions pac
277: ,fnd_sessions fs
278: ,pay_input_values_f_tl ivtl
279: WHERE per.person_id = asg1.person_id
280: AND asg2.person_id = per.person_id
281: AND asg2.primary_flag = 'Y'
1362: cursor csr_ssb_codes is
1363: select row_low_range_or_name
1364: from pay_user_tables put,
1365: pay_user_rows_f pur,
1366: fnd_sessions fs
1367: where
1368: put.user_table_name ='NO_SSB_CODE_RULES'
1369: and put.user_table_id = pur.user_table_id
1370: and fs.session_id = userenv('sessionid')