DBA Data[Home] [Help]

APPS.PAY_IE_EOY_INCOMELEVY_REPORT dependencies on HR_SOFT_CODING_KEYFLEX

Line 453: hr_soft_coding_keyflex scl

449: ,c_person_id per_all_people_f.person_id%type) IS
450: SELECT scl.segment4 paye_ref
451: FROM per_all_assignments_f paaf,
452: pay_all_payrolls_f papf,
453: hr_soft_coding_keyflex scl
454: WHERE paaf.person_id = c_person_id
455: AND paaf.assignment_id=c_assignment_id
456: AND paaf.payroll_id = papf.payroll_id
457: /* 9255733 */

Line 492: ,hr_soft_coding_keyflex flex

488: SELECT max(pps.period_of_service_id)
489: FROM per_periods_of_service pps
490: ,per_assignments_f asg
491: ,pay_all_payrolls_f pay
492: ,hr_soft_coding_keyflex flex
493: WHERE pps.person_id = v_person_id
494: AND pps.person_id = asg.person_id
495: AND asg.period_of_service_id <> pps.period_of_service_id
496: AND asg.assignment_id = v_assignment_id