APPS.PAY_US_BAL_UPLOAD dependencies on HR_SOFT_CODING_KEYFLEX

Line 122: ,hr_soft_coding_keyflex SCL

118: ,p_effective_date date
119: ) is
120: select fnd_number.canonical_to_number(SCL.segment1) tax_unit_id
121: from per_assignments_f ASG
122: ,hr_soft_coding_keyflex SCL
123: where ASG.assignment_id = p_assignment_id
124: and SCL.soft_coding_keyflex_id = ASG.soft_coding_keyflex_id
125: and p_effective_date between ASG.effective_start_date
126: and ASG.effective_end_date;

Line 250: ,hr_soft_coding_Keyflex SCL

246: select nvl(greatest(p_expiry_date, min(ASS.effective_start_date),
247: min(PTP.start_date)),
248: END_OF_TIME)
249: from per_assignments_f ASS
250: ,hr_soft_coding_Keyflex SCL
251: ,per_time_periods PTP
252: where ASS.assignment_id = p_assignment_id
253: and ASS.effective_start_date <= p_upload_date
254: and ASS.effective_end_date >= p_expiry_date

Line 309: ,hr_soft_coding_keyflex SCL

305: ) is
306: select nvl(greatest(min(ASS.effective_start_date), min(PTP.start_date)),
307: END_OF_TIME)
308: from per_assignments_f ASS
309: ,hr_soft_coding_keyflex SCL
310: ,per_time_periods PTP
311: where ASS.assignment_id = p_assignment_id
312: and SCL.soft_coding_keyflex_id = ASS.soft_coding_keyflex_id
313: and ASS.effective_start_date <= p_upload_date