[Home] [Help]
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
253: WHERE ppf.business_group_id = p_bus_grp_id
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
278: AND ppf.person_id = paf.person_id
303: IS
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
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
369: AND paf.period_of_service_id = ppos.period_of_service_id
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
425: AND paf.period_of_service_id = ppos.period_of_service_id
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
457: AND paf.period_of_service_id = ppos.period_of_service_id
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
490: AND paf.period_of_service_id = ppos.period_of_service_id
515: IS
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
571: ,p_asg_action_id NUMBER)
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
627: ,p_max_asg_id NUMBER)
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
683: IS
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
735: IS
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
783: ,p_max_asg_id NUMBER)
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
846: ,p_max_asg_id NUMBER)
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
891: IS
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
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 (+)
943: AND ppp.org_payment_method_id = pop.org_payment_method_id
970: IS
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