eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FI_GENERAL dependencies on PAY_ELEMENT_TYPES_F

Line 115: ,pay_element_types_f et

111: cursor csr_get_formula_id(p_effective_date in date,p_assignment_id in number,p_input_value in varchar2) is
112: SELECT FF.FORMULA_ID
113: FROM per_all_assignments_f asg1
114: ,pay_element_links_f el
115: ,pay_element_types_f et
116: ,pay_input_values_f iv1
117: ,pay_element_entries_f ee
118: ,pay_element_entry_values_f eev1
119: , ff_formulas_f ff

Line 274: ,pay_element_types_f et

270: cursor check_element_exist(p_assignment_id in number ,p_effective_date in date,p_element_name in varchar2 ) is
271: SELECT 1
272: FROM per_all_assignments_f asg
273: ,pay_element_links_f el
274: ,pay_element_types_f et
275: ,pay_element_entries_f ee
276: WHERE asg.assignment_id = p_assignment_id
277: AND et.element_name = p_element_name
278: AND et.legislation_code = 'FI'

Line 328: ,pay_element_types_f et

324: cursor csr_get_formula_id(p_effective_date in date,p_assignment_id in number,p_input_value in varchar2) is
325: SELECT FF.FORMULA_ID
326: FROM per_all_assignments_f asg1
327: ,pay_element_links_f el
328: ,pay_element_types_f et
329: ,pay_input_values_f iv1
330: ,pay_element_entries_f ee
331: ,pay_element_entry_values_f eev1
332: , ff_formulas_f ff

Line 447: ,pay_element_types_f et

443: CURSOR get_details(p_assignment_id NUMBER,p_effective_date DATE , p_input_value VARCHAR2 ) IS
444: SELECT eev1.SCREEN_ENTRY_VALUE
445: FROM per_all_assignments_f asg1
446: ,pay_element_links_f el
447: ,pay_element_types_f et
448: ,pay_input_values_f iv1
449: ,pay_element_entries_f ee
450: ,pay_element_entry_values_f eev1
451: WHERE asg1.assignment_id = p_assignment_id

Line 547: ,pay_element_types_f et

543: CURSOR get_details(p_assignment_id NUMBER,p_effective_date DATE , p_input_value VARCHAR2 ) IS
544: SELECT eev1.SCREEN_ENTRY_VALUE
545: FROM per_all_assignments_f asg1
546: ,pay_element_links_f el
547: ,pay_element_types_f et
548: ,pay_input_values_f iv1
549: ,pay_element_entries_f ee
550: ,pay_element_entry_values_f eev1
551: WHERE asg1.assignment_id = p_assignment_id

Line 692: ,pay_element_types_f et

688: FROM per_all_assignments_f asg1
689: ,per_all_assignments_f asg2
690: ,per_all_people_f per
691: ,pay_element_links_f el
692: ,pay_element_types_f et
693: ,pay_input_values_f iv1
694: ,pay_element_entries_f ee
695: ,pay_element_entry_values_f eev1
696: WHERE asg1.assignment_id = p_assignment_id

Line 780: ,pay_element_types_f et

776: FROM per_all_assignments_f asg1
777: ,per_all_assignments_f asg2
778: ,per_all_people_f per
779: ,pay_element_links_f el
780: ,pay_element_types_f et
781: ,pay_input_values_f iv1
782: ,pay_element_entries_f ee
783: ,pay_element_entry_values_f eev1
784: WHERE asg1.assignment_id = p_assignment_id

Line 906: ,pay_element_types_f et

902: SELECT TO_NUMBER(TO_CHAR(ee.effective_start_date, 'J')) julian_effective_date
903: FROM per_all_assignments_f asg1
904: ,per_all_people_f per
905: ,pay_element_links_f el
906: ,pay_element_types_f et
907: ,pay_element_entries_f ee
908: WHERE asg1.assignment_id = p_assignment_id
909: AND per.person_id = asg1.person_id
910: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date

Line 1935: ,pay_element_types_f et

1931: IS
1932: SELECT eev1.SCREEN_ENTRY_VALUE
1933: FROM per_all_assignments_f asg1
1934: ,pay_element_links_f el
1935: ,pay_element_types_f et
1936: ,pay_input_values_f iv1
1937: ,pay_element_entries_f ee
1938: ,pay_element_entry_values_f eev1
1939: WHERE asg1.assignment_id = p_assignment_id