[Home] [Help]
121: ,p_leg_emp_id IN NUMBER
122: ,p_effective_date IN DATE)
123: RETURN NUMBER IS
124:
125: l_hours per_all_assignments_f.normal_hours%TYPE;
126: l_freq per_all_assignments_f.frequency%TYPE;
127: l_default_work_pattern VARCHAR2(30);
128: l_work_days_week NUMBER ;
129: l_value NUMBER ;
122: ,p_effective_date IN DATE)
123: RETURN NUMBER IS
124:
125: l_hours per_all_assignments_f.normal_hours%TYPE;
126: l_freq per_all_assignments_f.frequency%TYPE;
127: l_default_work_pattern VARCHAR2(30);
128: l_work_days_week NUMBER ;
129: l_value NUMBER ;
130:
133: paaf.frequency
134: ,paaf.normal_hours
135: ,hsck.segment10 default_work_pattern
136: FROM
137: per_all_assignments_f paaf
138: ,hr_soft_coding_keyflex hsck
139: WHERE
140: paaf.assignment_id = p_assignment_id
141: AND paaf.assignment_status_type_id = 1
252: ,peevf.screen_entry_value absence_reason
253: ,paaf.payroll_id payroll_id
254: ,ppf.period_type period_type
255: FROM
256: per_all_assignments_f paaf
257: ,pay_element_entries_f peef
258: ,pay_element_types_f petf
259: ,per_jobs pj
260: ,pay_element_entry_values_f peevf
296: ,decode(hl.postal_code,NULL,' ',','||substr(hl.postal_code,1,5)) le_postalcode
297: ,substr(p_le_phone_number,1,30) le_phone
298: ,substr(p_le_email_addr,1,30) le_email
299: FROM
300: -- per_all_assignments_f paaf
301: -- ,hr_soft_coding_keyflex hsck
302: hr_all_organization_units haou
303: ,hr_locations hl
304: WHERE
338: ,hsck.segment4 employee_group
339: ,hsck.segment1 le_id
340: ,hsck.segment10 asg_work_pattern
341: FROM
342: per_all_assignments_f paaf
343: ,hr_soft_coding_keyflex hsck
344: WHERE
345: paaf.assignment_id = p_assignment_id
346: AND p_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date