DBA Data[Home] [Help]

APPS.PAY_AU_PAYE_FF dependencies on HR_SOFT_CODING_KEYFLEX

Line 276: hr_soft_coding_keyflex hsck

272:
273: cursor get_legal_emp_start_date (c_assignment_id per_all_assignments_f.assignment_id%type) is
274: select min(effective_start_date)
275: from per_all_assignments_f paf,
276: hr_soft_coding_keyflex hsck
277: where paf.assignment_id = c_assignment_id
278: and paf.SOFT_CODING_KEYFLEX_ID = hsck.soft_coding_keyflex_id
279: and hsck.segment1 = p_tax_unit_id
280: AND paf.effective_start_date <= l_period_end

Line 296: hr_soft_coding_keyflex hsck

292: from per_time_periods ptp
293: ,per_time_periods ptp1
294: where exists (select 'EXISTS' from
295: per_assignments_f paf,
296: hr_soft_coding_keyflex hsck
297: where paf.assignment_id = p_assignment_id
298: and paf.SOFT_CODING_KEYFLEX_ID = hsck.soft_coding_keyflex_id
299: and hsck.segment1 = p_tax_unit_id
300: AND paf.effective_start_date <= l_period_end

Line 638: hr_soft_coding_keyflex hsck

634: select count(DISTINCT ptp.time_period_id)
635: from per_time_periods ptp
636: where exists (select 'EXISTS' from
637: per_assignments_f paf,
638: hr_soft_coding_keyflex hsck
639: where paf.assignment_id = p_assignment_id
640: and paf.SOFT_CODING_KEYFLEX_ID = hsck.soft_coding_keyflex_id
641: and hsck.segment1 = c_tax_unit_id
642: AND paf.effective_start_date <= c_end_date