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_SE_ABSENCE dependencies on PER_ALL_ASSIGNMENTS_F

Line 63: FROM PER_ALL_ASSIGNMENTS_F ASG

59: ,HR_ORGANIZATION_INFORMATION hoi2
60: ,HR_ORGANIZATION_INFORMATION hoi3
61: ,HR_ORGANIZATION_INFORMATION hoi4
62: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
63: FROM PER_ALL_ASSIGNMENTS_F ASG
64: ,HR_SOFT_CODING_KEYFLEX SCL
65: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
66: AND ASG.SOFT_CODING_KEYFLEX_ID = SCL.SOFT_CODING_KEYFLEX_ID
67: AND p_effective_date BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE ) X

Line 91: FROM PER_ALL_ASSIGNMENTS_F ASG

87: ,HR_ORGANIZATION_INFORMATION hoi2
88: ,HR_ORGANIZATION_INFORMATION hoi3
89: ,HR_ORGANIZATION_INFORMATION hoi4
90: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
91: FROM PER_ALL_ASSIGNMENTS_F ASG
92: ,HR_SOFT_CODING_KEYFLEX SCL
93: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
94: AND ASG.SOFT_CODING_KEYFLEX_ID = SCL.SOFT_CODING_KEYFLEX_ID
95: AND p_effective_date BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE ) X

Line 140: FROM per_all_assignments_f asg1

136:
137:
138: CURSOR csr_abs_attendance_id (l_asg_id number, l_eff_dt date, l_inp_val_name varchar2, l_start_dt date, l_end_dt date) IS
139: SELECT eev1.screen_entry_value screen_entry_value
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

Line 141: ,per_all_assignments_f asg2

137:
138: CURSOR csr_abs_attendance_id (l_asg_id number, l_eff_dt date, l_inp_val_name varchar2, l_start_dt date, l_end_dt date) IS
139: SELECT eev1.screen_entry_value screen_entry_value
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

Line 191: FROM per_all_assignments_f paaf,

187: ,l_normal_hours
188: ,l_frequency
189: ,l_hour_sal
190: ,l_employee_category
191: FROM per_all_assignments_f paaf,
192: per_all_people_f papf,
193: hr_soft_coding_keyflex hsck
194: WHERE paaf.assignment_id = p_assignment_id
195: AND paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id

Line 438: FROM per_all_assignments_f asg1

434: -- ORDER BY paa.date_end ;
435:
436:
437: SELECT eev1.screen_entry_value screen_entry_value
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

Line 439: ,per_all_assignments_f asg2

435:
436:
437: SELECT eev1.screen_entry_value screen_entry_value
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

Line 501: FROM per_all_assignments_f paaf,

497: SELECT papf.person_id ,
498: hourly_salaried_code
499: INTO l_person_id ,
500: p_asg_hour_sal
501: FROM per_all_assignments_f paaf,
502: per_all_people_f papf,
503: hr_soft_coding_keyflex hsck
504: WHERE paaf.assignment_id = p_assignment_id
505: AND paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id

Line 717: FROM per_all_assignments_f asg1

713: -- ORDER BY paa.date_end ;
714:
715:
716: SELECT eev1.screen_entry_value screen_entry_value
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

Line 718: ,per_all_assignments_f asg2

714:
715:
716: SELECT eev1.screen_entry_value screen_entry_value
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

Line 752: FROM per_all_assignments_f asg1

748: --ORDER BY paa.date_end ;
749:
750: CURSOR csr_check_override (l_asg_id number, l_eff_dt date, l_inp_val_name varchar2, l_start_dt date, l_end_dt date) IS
751: SELECT eev1.screen_entry_value screen_entry_value
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

Line 753: ,per_all_assignments_f asg2

749:
750: CURSOR csr_check_override (l_asg_id number, l_eff_dt date, l_inp_val_name varchar2, l_start_dt date, l_end_dt date) IS
751: SELECT eev1.screen_entry_value screen_entry_value
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

Line 904: FROM per_all_assignments_f paaf

900: csr_v_start_date DATE, csr_v_end_date DATE )
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

Line 1033: FROM per_all_assignments_f paaf,

1029: ,l_normal_hours
1030: ,l_normal_time_start
1031: ,l_normal_time_end
1032: ,p_sex
1033: FROM per_all_assignments_f paaf,
1034: per_all_people_f papf,
1035: hr_soft_coding_keyflex hsck
1036: WHERE paaf.assignment_id = p_assignment_id
1037: AND paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id

Line 3428: FROM per_all_assignments_f paaf,

3424:
3425: /*SELECT hourly_salaried_code
3426: INTO
3427: l_asg_hour_sal
3428: FROM per_all_assignments_f paaf,
3429: per_all_people_f papf,
3430: hr_soft_coding_keyflex hsck
3431: WHERE paaf.assignment_id = p_assignment_id
3432: AND paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id

Line 3492: FROM per_all_assignments_f asg1

3488: -- ORDER BY paa.date_end ;
3489:
3490:
3491: SELECT eev1.screen_entry_value screen_entry_value
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

Line 3493: ,per_all_assignments_f asg2

3489:
3490:
3491: SELECT eev1.screen_entry_value screen_entry_value
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

Line 3588: FROM per_all_assignments_f asg1

3584: -- ORDER BY paa.date_end ;
3585:
3586:
3587: SELECT eev1.screen_entry_value screen_entry_value
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

Line 3589: ,per_all_assignments_f asg2

3585:
3586:
3587: SELECT eev1.screen_entry_value screen_entry_value
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