[Home] [Help]
334: (ppos.actual_termination_date, ppos.date_start)/12))) ||' Days' los
335: ,hou.name department
336: ,org.name ORGANIZATION
337: ,loc.location_code location
338: FROM per_people_f ppf
339: ,per_assignments_f paf
340: ,per_periods_of_service ppos
341: ,hr_soft_coding_keyflex hsck
342: ,hr_organization_units hou
363: IS
364: SELECT nvl(pp.name,pj.name) designation
365: FROM per_positions pp
366: ,per_jobs pj
367: ,per_people_f ppf
368: ,per_assignments_f paf
369: ,per_periods_of_service ppos
370: WHERE ppf.business_group_id = p_bus_grp_id
371: AND ppf.employee_number = p_employee_number
399: ,sum(prrv.result_value) amount
400: ,pec.classification_name classification
401: ,pet.element_name elename
402: FROM per_assignments_f paf
403: ,per_people_f ppf
404: ,pay_element_types_f pet
405: ,pay_input_values_f piv
406: ,pay_assignment_actions paa
407: ,pay_run_results prr
456: IS
457: SELECT max(paa.assignment_action_id)
458: FROM pay_assignment_actions paa
459: ,pay_payroll_actions ppa
460: ,per_people_f ppf
461: ,per_assignments_f paf
462: ,per_periods_of_service ppos
463: WHERE ppf.employee_number = p_employee_number
464: AND ppf.person_id = paf.person_id
495: ,p_term_date DATE )
496: IS
497: SELECT max(last_day(pos.last_standard_process_date))
498: FROM per_periods_of_service pos
499: ,per_people_f ppf
500: WHERE ppf.employee_number = p_employee_number
501: AND ppf.person_id = pos.person_id
502: AND ppf.business_group_id = p_bus_grp_id
503: AND pos.actual_termination_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
512: IS
513: SELECT max(paa.assignment_action_id)
514: FROM pay_assignment_actions paa
515: ,pay_payroll_actions ppa
516: ,per_people_f ppf
517: ,per_assignments_f paf
518: ,per_periods_of_service ppos
519: WHERE ppf.employee_number = p_employee_number
520: AND ppf.person_id = paf.person_id
544: IS
545: SELECT max(paa.assignment_action_id)
546: FROM pay_assignment_actions paa
547: ,pay_payroll_actions ppa
548: ,per_people_f ppf
549: ,per_assignments_f paf
550: ,per_periods_of_service ppos
551: WHERE ppf.employee_number = p_employee_number
552: AND ppf.person_id = paf.person_id
577: IS
578: SELECT max(paa.assignment_action_id)
579: FROM pay_assignment_actions paa
580: ,pay_payroll_actions ppa
581: ,per_people_f ppf
582: ,per_assignments_f paf
583: ,per_periods_of_service ppos
584: WHERE ppf.employee_number = p_employee_number
585: AND ppf.person_id = paf.person_id
612: SELECT piv.name description
613: ,INITCAP(peev.screen_entry_value) loan_type
614: ,prrv.result_value amount
615: FROM per_assignments_f paf
616: ,per_people_f ppf
617: ,pay_element_types_f pet
618: ,pay_input_values_f piv
619: ,pay_element_entries_f pee
620: ,pay_element_entry_values_f peev
668: IS
669: SELECT piv.name description
670: ,prrv.result_value amount
671: FROM per_assignments_f paf
672: ,per_people_f ppf
673: ,pay_element_types_f pet
674: ,pay_input_values_f piv
675: ,pay_element_entries_f pee
676: ,pay_element_classifications pec
724: IS
725: SELECT prrv.result_value amount
726: ,piv.name description
727: FROM per_assignments_f paf
728: ,per_people_f ppf
729: ,pay_element_types_f pet
730: ,pay_input_values_f piv
731: ,pay_assignment_actions paa
732: ,pay_run_results prr
780: SELECT piv.name description
781: ,prrv.result_value amount
782: ,nvl(pet.reporting_name, pet.element_name) Element
783: FROM per_assignments_f paf
784: ,per_people_f ppf
785: ,pay_element_types_f pet
786: ,pay_input_values_f piv
787: ,pay_assignment_actions paa
788: ,pay_run_results prr
832: SELECT piv.name description
833: ,prrv.result_value amount
834: ,nvl(pet.reporting_name, pet.element_name) Element
835: FROM per_assignments_f paf
836: ,per_people_f ppf
837: ,pay_element_types_f pet
838: ,pay_input_values_f piv
839: ,pay_assignment_actions paa
840: ,pay_run_results prr
881: SELECT sum(prrv.result_value) amount
882: ,nvl(pet.reporting_name, pet.element_name) description
883: ,pet.element_name elename
884: FROM per_assignments_f paf
885: ,per_people_f ppf
886: ,pay_element_types_f pet
887: ,pay_input_values_f piv
888: ,pay_assignment_actions paa
889: ,pay_run_results prr
944: IS
945: SELECT /*+ ORDERED */
946: SUM(ABS(fnd_number.canonical_to_number(prrv.result_value))) amount
947: FROM per_assignments_f paf
948: ,per_people_f ppf
949: ,pay_element_types_f pet
950: ,pay_input_values_f piv
951: ,pay_assignment_actions paa
952: -- ,pay_element_entries_f peef-- Added as a part of bug fix 4774108
989: SELECT to_number(pay_balance_pkg.get_value(pdb.defined_balance_id
990: , paa.assignment_action_id)) amount
991: , pbt.balance_name description
992: FROM per_assignments_f paf
993: ,per_people_f ppf
994: ,pay_assignment_actions paa
995: ,per_periods_of_service ppos
996: ,pay_balance_types pbt
997: ,pay_balance_dimensions pbd
1031: ,pay_payment_types ppt
1032: ,pay_action_interlocks pci
1033: ,pay_payroll_actions ppa
1034: ,pay_assignment_actions paa
1035: ,per_people_f ppf
1036: ,per_assignments_f paf
1037: ,per_periods_of_service ppos
1038: WHERE ppp.assignment_action_id = pci.locking_action_id
1039: AND ppp.personal_payment_method_id = ppm.personal_payment_method_id (+)
1068: SELECT to_number(pay_balance_pkg.get_value(pdb.defined_balance_id
1069: , paa.assignment_action_id)) amount
1070: , pbt.balance_name description
1071: FROM per_assignments_f paf
1072: ,per_people_f ppf
1073: ,pay_assignment_actions paa
1074: ,per_periods_of_service ppos
1075: ,pay_balance_types pbt
1076: ,pay_balance_dimensions pbd