[Home] [Help]
110: --To fetch the hourly rate from person form
111:
112: CURSOR csr_Person_Hourly_Rate IS
113: SELECT PER_INFORMATION6 AS Hourly_Rate --Hourly/Salaried
114: FROM PER_ALL_PEOPLE_F PER
115: WHERE PER.PERSON_ID = l_person_id
116: AND P_EFFECTIVE_DATE BETWEEN PER.EFFECTIVE_START_DATE
117: AND PER.EFFECTIVE_END_DATE;
118:
117: AND PER.EFFECTIVE_END_DATE;
118:
119: CURSOR csr_Person_Salary_Rate IS
120: SELECT PER_INFORMATION7 AS Salary_Rate --Hourly/Salaried
121: FROM PER_ALL_PEOPLE_F PER
122: WHERE PER.PERSON_ID = l_person_id
123: AND P_EFFECTIVE_DATE BETWEEN PER.EFFECTIVE_START_DATE
124: AND PER.EFFECTIVE_END_DATE;
125:
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
146: ,pay_element_entries_f ee
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
196: AND papf.person_id=paaf.person_id
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
444: ,pay_element_entries_f ee
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
506: AND papf.person_id=paaf.person_id
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
723: ,pay_element_entries_f ee
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
758: ,pay_element_entries_f ee
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
1038: AND papf.person_id=paaf.person_id
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
3433: AND papf.person_id=paaf.person_id
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
3498: ,pay_element_entries_f ee
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
3594: ,pay_element_entries_f ee