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_LINKS_F

Line 114: ,pay_element_links_f el

110: return NUMBER is
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

Line 273: ,pay_element_links_f el

269: l_element_exist number;
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

Line 327: ,pay_element_links_f el

323: return NUMBER is
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

Line 446: ,pay_element_links_f el

442: --
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

Line 546: ,pay_element_links_f el

542: --
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

Line 691: ,pay_element_links_f el

687: ,eev1.screen_entry_value screen_entry_value
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

Line 779: ,pay_element_links_f el

775: SELECT eev1.screen_entry_value tax_days
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

Line 905: ,pay_element_links_f el

901: CURSOR get_tax_details(p_assignment_id NUMBER , p_effective_date DATE) IS
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

Line 1934: ,pay_element_links_f el

1930: p_input_value_name varchar2)
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