[Home] [Help]
141: ,per_all_assignments_f asg2
142: ,per_all_people_f per
143: ,pay_element_links_f el
144: ,pay_element_types_f et
145: ,pay_input_values_f iv1
146: ,pay_element_entries_f ee
147: ,pay_element_entry_values_f eev1
148: WHERE asg1.assignment_id = l_asg_id
149: AND l_eff_dt BETWEEN asg1.effective_start_date AND asg1.effective_end_date
439: ,per_all_assignments_f asg2
440: ,per_all_people_f per
441: ,pay_element_links_f el
442: ,pay_element_types_f et
443: ,pay_input_values_f iv1
444: ,pay_element_entries_f ee
445: ,pay_element_entry_values_f eev1
446: WHERE asg1.assignment_id = p_assignment_id --34040 --l_asg_id
447: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
718: ,per_all_assignments_f asg2
719: ,per_all_people_f per
720: ,pay_element_links_f el
721: ,pay_element_types_f et
722: ,pay_input_values_f iv1
723: ,pay_element_entries_f ee
724: ,pay_element_entry_values_f eev1
725: WHERE asg1.assignment_id = p_assignment_id --34040 --l_asg_id
726: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
753: ,per_all_assignments_f asg2
754: ,per_all_people_f per
755: ,pay_element_links_f el
756: ,pay_element_types_f et
757: ,pay_input_values_f iv1
758: ,pay_element_entries_f ee
759: ,pay_element_entry_values_f eev1
760: WHERE asg1.assignment_id = l_asg_id
761: AND l_eff_dt BETWEEN asg1.effective_start_date AND asg1.effective_end_date
810: /*FROM pay_assignment_actions paa,
811: pay_payroll_actions ppa,
812: pay_run_results prr,
813: pay_run_result_values prrv1,
814: pay_input_values_f pivf,
815: pay_element_types_f petf
816: /* pay_run_result_values prrv2,
817: pay_run_result_values prrv3*/
818: /*WHERE ppa.effective_date BETWEEN p_group_start_date --'01-jun-1999' --p_report_start_date
859:
860: CURSOR csr_input(p_element_type_id number,p_input_value varchar2)
861: IS
862: SELECT input_value_id FROM
863: pay_input_values_f
864: WHERE name=p_input_value
865: AND element_type_id=p_element_type_id;
866:
867: CURSOR csr_run_result_value(csr_v_assignment_id NUMBER,
905: ,pay_element_types_f et
906: ,pay_element_entries_f ee
907: ,pay_element_entry_values_f peevf1
908: ,pay_element_entry_values_f peevf2
909: ,pay_input_values_f pivf1
910: ,pay_input_values_f pivf2
911: WHERE paaf.assignment_id = csr_v_assignment_id --38399 --p_assignment_id
912: AND csr_v_end_date /*p_effective_date*/ BETWEEN paaf.effective_start_date AND paaf.effective_end_date
913: AND et.element_name = 'Sickness Details'
906: ,pay_element_entries_f ee
907: ,pay_element_entry_values_f peevf1
908: ,pay_element_entry_values_f peevf2
909: ,pay_input_values_f pivf1
910: ,pay_input_values_f pivf2
911: WHERE paaf.assignment_id = csr_v_assignment_id --38399 --p_assignment_id
912: AND csr_v_end_date /*p_effective_date*/ BETWEEN paaf.effective_start_date AND paaf.effective_end_date
913: AND et.element_name = 'Sickness Details'
914: AND et.legislation_code = 'SE'
3493: ,per_all_assignments_f asg2
3494: ,per_all_people_f per
3495: ,pay_element_links_f el
3496: ,pay_element_types_f et
3497: ,pay_input_values_f iv1
3498: ,pay_element_entries_f ee
3499: ,pay_element_entry_values_f eev1
3500: WHERE asg1.assignment_id = csr_v_assignment_id --34040 --l_asg_id
3501: AND p_payroll_end BETWEEN asg1.effective_start_date AND asg1.effective_end_date
3589: ,per_all_assignments_f asg2
3590: ,per_all_people_f per
3591: ,pay_element_links_f el
3592: ,pay_element_types_f et
3593: ,pay_input_values_f iv1
3594: ,pay_element_entries_f ee
3595: ,pay_element_entry_values_f eev1
3596: WHERE asg1.assignment_id = p_assignment_id --34040 --l_asg_id
3597: AND p_pay_end_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date