[Home] [Help]
39: SELECT nvl(min(peev.screen_entry_value), 'NP')
40: FROM fnd_sessions fs,
41: pay_element_types_f pet,
42: pay_input_values_f piv,
43: pay_element_entries_f peef,
44: pay_element_entry_values_f peev
45: WHERE fs.session_id = userenv('sessionid')
46: AND pet.element_name = 'NI'
47: AND pet.business_group_id IS NULL
109: per_all_assignments_f paaf1,
110: per_all_assignments_f paaf2,
111: pay_all_payrolls_f ppf,
112: hr_soft_coding_keyflex scl,
113: pay_element_entries_f peef,
114: pay_element_entry_values_f peev
115: WHERE paaf1.assignment_id = p_assignment_id
116: AND fs.session_id = userenv('sessionid')
117: AND fs.effective_date BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
136: per_all_assignments_f paaf1,
137: per_all_assignments_f paaf2,
138: pay_all_payrolls_f ppf,
139: hr_soft_coding_keyflex scl,
140: pay_element_entries_f peef,
141: pay_element_entry_values_f peev
142: WHERE paaf1.assignment_id = p_assignment_id
143: AND fs.session_id = userenv('sessionid')
144: AND fs.effective_date BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
227: per_all_assignments_f paaf1,
228: per_all_assignments_f paaf2,
229: pay_all_payrolls_f ppf,
230: hr_soft_coding_keyflex scl,
231: pay_element_entries_f peef,
232: pay_element_entry_values_f peev
233: WHERE paaf1.assignment_id = p_assignment_id
234: AND fs.session_id = userenv('sessionid')
235: AND fs.effective_date BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
252: per_all_assignments_f paaf1,
253: per_all_assignments_f paaf2,
254: pay_all_payrolls_f ppf,
255: hr_soft_coding_keyflex scl,
256: pay_element_entries_f peef,
257: pay_element_entry_values_f peev
258: WHERE paaf1.assignment_id = p_assignment_id
259: AND fs.session_id = userenv('sessionid')
260: AND fs.effective_date BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
372: per_all_assignments_f paaf1,
373: per_all_assignments_f paaf2,
374: pay_all_payrolls_f ppf,
375: hr_soft_coding_keyflex scl,
376: pay_element_entries_f peef,
377: pay_element_entry_values_f peev
378: WHERE paaf1.assignment_id = p_assignment_id
379: AND fs.session_id = userenv('sessionid')
380: AND fs.effective_date BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
397: per_all_assignments_f paaf1,
398: per_all_assignments_f paaf2,
399: pay_all_payrolls_f ppf,
400: hr_soft_coding_keyflex scl,
401: pay_element_entries_f peef,
402: pay_element_entry_values_f peev
403: WHERE paaf1.assignment_id = p_assignment_id
404: AND fs.session_id = userenv('sessionid')
405: AND fs.effective_date BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
536: per_all_assignments_f paaf1,
537: per_all_assignments_f paaf2,
538: pay_all_payrolls_f ppf,
539: hr_soft_coding_keyflex scl,
540: pay_element_entries_f peef,
541: pay_element_entry_values_f peev
542: WHERE paaf1.assignment_id = p_assignment_id
543: AND fs.session_id = userenv('sessionid')
544: AND fs.effective_date BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
562: per_all_assignments_f paaf1,
563: per_all_assignments_f paaf2,
564: pay_all_payrolls_f ppf,
565: hr_soft_coding_keyflex scl,
566: pay_element_entries_f peef,
567: pay_element_entry_values_f peev
568: WHERE paaf1.assignment_id = p_assignment_id
569: AND fs.session_id = userenv('sessionid')
570: AND fs.effective_date BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date