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 PER_ALL_ASSIGNMENTS_F

Line 113: FROM per_all_assignments_f asg1

109: )
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

Line 272: FROM per_all_assignments_f asg

268: function element_exist(p_assignment_id in number ,p_date_earned in date,p_element_name in varchar2 ) return number is
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

Line 326: FROM per_all_assignments_f asg1

322: )
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

Line 445: FROM per_all_assignments_f asg1

441: ) RETURN NUMBER IS
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

Line 545: FROM per_all_assignments_f asg1

541: ) RETURN NUMBER IS
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

Line 657: FROM per_all_assignments_f asg1

653: l_local_unit hr_soft_coding_keyflex.segment2%TYPE;
654:
655: CURSOR c_local_unit(p_assignment_id NUMBER , p_effective_date DATE) IS
656: SELECT sck.segment2
657: FROM per_all_assignments_f asg1
658: , hr_soft_coding_keyflex sck
659: WHERE asg1.assignment_id = p_assignment_id
660: AND asg1.soft_coding_keyflex_id=sck.soft_coding_keyflex_id
661: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date;

Line 688: FROM per_all_assignments_f asg1

684: --
685: CURSOR get_details(p_assignment_id NUMBER , p_effective_date DATE , p_input_value VARCHAR2 ) IS
686: SELECT TO_NUMBER(TO_CHAR(ee.effective_start_date, 'J')) julian_effective_date
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

Line 689: ,per_all_assignments_f asg2

685: CURSOR get_details(p_assignment_id NUMBER , p_effective_date DATE , p_input_value VARCHAR2 ) IS
686: SELECT TO_NUMBER(TO_CHAR(ee.effective_start_date, 'J')) julian_effective_date
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

Line 776: FROM per_all_assignments_f asg1

772: ) RETURN NUMBER IS
773: --
774: CURSOR get_details(p_assignment_id NUMBER,p_effective_date DATE , p_input_value VARCHAR2 ) IS
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

Line 777: ,per_all_assignments_f asg2

773: --
774: CURSOR get_details(p_assignment_id NUMBER,p_effective_date DATE , p_input_value VARCHAR2 ) IS
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

Line 903: FROM per_all_assignments_f asg1

899: l_julian_effective_date NUMBER;
900:
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

Line 1183: FROM per_all_assignments_f asg1

1179: l_pension_rate hr_organization_information.org_information1%TYPE;
1180:
1181: CURSOR c_person_pension_num(p_assignment_id NUMBER , p_effective_date DATE) IS
1182: SELECT PER_INFORMATION15, PER_INFORMATION16, PER_INFORMATION24
1183: FROM per_all_assignments_f asg1
1184: ,per_all_people_f per
1185: WHERE asg1.assignment_id = p_assignment_id
1186: AND per.person_id = asg1.person_id
1187: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date

Line 1276: FROM per_all_assignments_f asg1

1272: l_retire_date VARCHAR2(150) ;
1273:
1274: CURSOR c_retire_date IS
1275: SELECT PER_INFORMATION8
1276: FROM per_all_assignments_f asg1
1277: ,per_all_people_f per
1278: WHERE asg1.assignment_id = p_assignment_id
1279: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
1280: AND p_effective_date BETWEEN per.effective_start_date AND per.effective_end_date

Line 1933: FROM per_all_assignments_f asg1

1929: p_element_name varchar2,
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

Line 1977: SELECT HOURLY_SALARIED_CODE FROM PER_ALL_ASSIGNMENTS_F WHERE ASSIGNMENT_ID=p_assignment_id and

1973: ) return varchar2 is
1974: cursor csr_hourly_salaried_type(p_assignment_id in number,
1975: p_date_earned in date)
1976: is
1977: SELECT HOURLY_SALARIED_CODE FROM PER_ALL_ASSIGNMENTS_F WHERE ASSIGNMENT_ID=p_assignment_id and
1978: p_date_earned between effective_start_date and effective_end_Date;
1979:
1980: p_hourly_salaried varchar2(1);
1981: