[Home] [Help]
244: || (1 + ppos.actual_termination_date - add_months(ppos.date_start
245: ,12*trunc(months_between
246: (ppos.actual_termination_date, ppos.date_start)/12))) ||' Days' los
247: ,hou.name department
248: FROM per_people_f ppf
249: ,per_assignments_f paf
250: ,per_periods_of_service ppos
251: ,hr_soft_coding_keyflex hsck
252: ,hr_organization_units hou
269: IS
270: SELECT nvl(pp.name,pj.name) designation
271: FROM per_positions pp
272: ,per_jobs pj
273: ,per_people_f ppf
274: ,per_assignments_f paf
275: ,per_periods_of_service ppos
276: WHERE ppf.business_group_id = p_bus_grp_id
277: AND ppf.employee_number = p_employee_number
304: SELECT nvl(pet.reporting_name, pet.element_name) description
305: ,sum(prrv.result_value) amount
306: ,pec.classification_name classification
307: FROM per_assignments_f paf
308: ,per_people_f ppf
309: ,pay_element_types_f pet
310: ,pay_input_values_f piv
311: ,pay_assignment_actions paa
312: ,pay_run_results prr
360: IS
361: SELECT max(paa.assignment_action_id)
362: FROM pay_assignment_actions paa
363: ,pay_payroll_actions ppa
364: ,per_people_f ppf
365: ,per_assignments_f paf
366: ,per_periods_of_service ppos
367: WHERE ppf.employee_number = p_employee_number
368: AND ppf.person_id = paf.person_id
399: ,p_term_date DATE )
400: IS
401: SELECT max(last_day(pos.last_standard_process_date))
402: FROM per_periods_of_service pos
403: ,per_people_f ppf
404: WHERE ppf.employee_number = p_employee_number
405: AND ppf.person_id = pos.person_id
406: AND ppf.business_group_id = p_bus_grp_id
407: AND pos.actual_termination_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
416: IS
417: SELECT max(paa.assignment_action_id)
418: FROM pay_assignment_actions paa
419: ,pay_payroll_actions ppa
420: ,per_people_f ppf
421: ,per_assignments_f paf
422: ,per_periods_of_service ppos
423: WHERE ppf.employee_number = p_employee_number
424: AND ppf.person_id = paf.person_id
448: IS
449: SELECT max(paa.assignment_action_id)
450: FROM pay_assignment_actions paa
451: ,pay_payroll_actions ppa
452: ,per_people_f ppf
453: ,per_assignments_f paf
454: ,per_periods_of_service ppos
455: WHERE ppf.employee_number = p_employee_number
456: AND ppf.person_id = paf.person_id
481: IS
482: SELECT max(paa.assignment_action_id)
483: FROM pay_assignment_actions paa
484: ,pay_payroll_actions ppa
485: ,per_people_f ppf
486: ,per_assignments_f paf
487: ,per_periods_of_service ppos
488: WHERE ppf.employee_number = p_employee_number
489: AND ppf.person_id = paf.person_id
516: SELECT piv.name description
517: ,INITCAP(peev.screen_entry_value) loan_type
518: ,prrv.result_value amount
519: FROM per_assignments_f paf
520: ,per_people_f ppf
521: ,pay_element_types_f pet
522: ,pay_input_values_f piv
523: ,pay_element_entries_f pee
524: ,pay_element_entry_values_f peev
572: IS
573: SELECT piv.name description
574: ,prrv.result_value amount
575: FROM per_assignments_f paf
576: ,per_people_f ppf
577: ,pay_element_types_f pet
578: ,pay_input_values_f piv
579: ,pay_element_entries_f pee
580: ,pay_element_classifications pec
628: IS
629: SELECT prrv.result_value amount
630: ,piv.name description
631: FROM per_assignments_f paf
632: ,per_people_f ppf
633: ,pay_element_types_f pet
634: ,pay_input_values_f piv
635: ,pay_assignment_actions paa
636: ,pay_run_results prr
684: SELECT piv.name description
685: ,prrv.result_value amount
686: ,nvl(pet.reporting_name, pet.element_name) Element
687: FROM per_assignments_f paf
688: ,per_people_f ppf
689: ,pay_element_types_f pet
690: ,pay_input_values_f piv
691: ,pay_assignment_actions paa
692: ,pay_run_results prr
736: SELECT piv.name description
737: ,prrv.result_value amount
738: ,nvl(pet.reporting_name, pet.element_name) Element
739: FROM per_assignments_f paf
740: ,per_people_f ppf
741: ,pay_element_types_f pet
742: ,pay_input_values_f piv
743: ,pay_assignment_actions paa
744: ,pay_run_results prr
784: IS
785: SELECT sum(prrv.result_value) amount
786: ,nvl(pet.reporting_name, pet.element_name) description
787: FROM per_assignments_f paf
788: ,per_people_f ppf
789: ,pay_element_types_f pet
790: ,pay_input_values_f piv
791: ,pay_assignment_actions paa
792: ,pay_run_results prr
847: IS
848: SELECT /*+ ORDERED */
849: SUM(ABS(fnd_number.canonical_to_number(prrv.result_value))) amount
850: FROM per_assignments_f paf
851: ,per_people_f ppf
852: ,pay_element_types_f pet
853: ,pay_input_values_f piv
854: ,pay_assignment_actions paa
855: -- ,pay_element_entries_f peef-- Added as a part of bug fix 4774108
892: SELECT to_number(pay_balance_pkg.get_value(pdb.defined_balance_id
893: , paa.assignment_action_id)) amount
894: , pbt.balance_name description
895: FROM per_assignments_f paf
896: ,per_people_f ppf
897: ,pay_assignment_actions paa
898: ,per_periods_of_service ppos
899: ,pay_balance_types pbt
900: ,pay_balance_dimensions pbd
934: ,pay_payment_types ppt
935: ,pay_action_interlocks pci
936: ,pay_payroll_actions ppa
937: ,pay_assignment_actions paa
938: ,per_people_f ppf
939: ,per_assignments_f paf
940: ,per_periods_of_service ppos
941: WHERE ppp.assignment_action_id = pci.locking_action_id
942: AND ppp.personal_payment_method_id = ppm.personal_payment_method_id (+)
971: SELECT to_number(pay_balance_pkg.get_value(pdb.defined_balance_id
972: , paa.assignment_action_id)) amount
973: , pbt.balance_name description
974: FROM per_assignments_f paf
975: ,per_people_f ppf
976: ,pay_assignment_actions paa
977: ,per_periods_of_service ppos
978: ,pay_balance_types pbt
979: ,pay_balance_dimensions pbd