DBA Data[Home] [Help]

APPS.PAY_NO_EOY_ARCHIVE dependencies on HR_SOFT_CODING_KEYFLEX

Line 650: ,hr_soft_coding_keyflex sck

646: SELECT paf.assignment_id
647: ,greatest( trunc(p_effective_date,'Y'), paf.effective_start_date) start_date
648: ,least( p_effective_date, paf.effective_end_date) end_date
649: FROM per_all_assignments_f paf
650: ,hr_soft_coding_keyflex sck
651: ,hr_organization_information hoi
652: ,per_assignment_status_types pas
653: WHERE paf.person_id = p_person_id
654: AND sck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id

Line 750: ,hr_soft_coding_keyflex sck

746: CURSOR csr_asg_contribution is
747: SELECT greatest( trunc(p_effective_date,'Y'), paf.effective_start_date) start_date
748: ,least( p_effective_date, paf.effective_end_date) end_date
749: FROM per_all_assignments_f paf
750: ,hr_soft_coding_keyflex sck
751: ,hr_organization_information hoi
752: ,per_assignment_status_types pas
753: WHERE paf.person_id = p_person_id
754: AND sck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id