DBA Data[Home] [Help]

APPS.PAY_CA_YEER_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 3403: hr_soft_coding_keyflex hsck

3399:
3400: cursor cur_rl_tax_unit_id( cp_asg_id in number ) is
3401: select nvl(hsck.segment1, hsck.segment11)
3402: from per_all_assignments_f paf,
3403: hr_soft_coding_keyflex hsck
3404: where paf.assignment_id = cp_asg_id
3405: and add_months(trunc(to_date(sv_reporting_year,'YYYY'),'Y'),12)-1 between
3406: paf.effective_start_date and paf.effective_end_date
3407: and hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id;