DBA Data[Home] [Help]

APPS.PAY_DK_SICKNESS_DP201 dependencies on HR_SOFT_CODING_KEYFLEX

Line 138: ,hr_soft_coding_keyflex hsck

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
142: AND p_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date

Line 301: -- ,hr_soft_coding_keyflex hsck

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
305: -- paaf.assignment_id = p_assignment_id

Line 343: ,hr_soft_coding_keyflex hsck

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
347: AND hsck.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id;