APPS.PAY_SE_ABSENCE dependencies on PAY_ELEMENT_TYPES_F

Line 144: ,pay_element_types_f et

140: FROM per_all_assignments_f asg1
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

Line 442: ,pay_element_types_f et

438: FROM per_all_assignments_f asg1
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

Line 721: ,pay_element_types_f et

717: FROM per_all_assignments_f asg1
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

Line 756: ,pay_element_types_f et

752: FROM per_all_assignments_f asg1
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

Line 815: pay_element_types_f petf

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
819: /* AND p_group_end_date /*'01-jun-2000' */--p_report_end_date

Line 856: pay_element_types_f

852:
853: CURSOR csr_element(p_element_name VARCHAR2)
854: IS
855: SELECT element_type_id FROM
856: pay_element_types_f
857: WHERE element_name=p_element_name
858: AND legislation_code='SE';
859:
860: CURSOR csr_input(p_element_type_id number,p_input_value varchar2)

Line 905: ,pay_element_types_f et

901: IS
902: SELECT greatest(fnd_date.canonical_to_date(peevf1.SCREEN_ENTRY_VALUE),csr_v_start_date) date_start,
903: least(fnd_date.canonical_to_date(peevf2.SCREEN_ENTRY_VALUE),csr_v_end_date) date_end
904: FROM per_all_assignments_f paaf
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

Line 3496: ,pay_element_types_f et

3492: FROM per_all_assignments_f asg1
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

Line 3592: ,pay_element_types_f et

3588: FROM per_all_assignments_f asg1
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