DBA Data[Home] [Help]

APPS.PAY_CA_YEER_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 3034: hr_soft_coding_keyflex hsck

3030:
3031: cursor cur_rl_tax_unit_id( cp_asg_id in number ) is
3032: select nvl(hsck.segment1, hsck.segment11)
3033: from per_all_assignments_f paf,
3034: hr_soft_coding_keyflex hsck
3035: where paf.assignment_id = cp_asg_id
3036: and add_months(trunc(to_date(sv_reporting_year,'YYYY'),'Y'),12)-1 between
3037: paf.effective_start_date and paf.effective_end_date
3038: and hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id;