DBA Data[Home] [Help]

APPS.PAY_PYUCSLIS_PKG dependencies on PER_POS_STRUCTURE_VERSIONS

Line 639: FROM per_pos_structure_versions v

635: AND ol.security_profile_id= l_security_profile_id)
636: START WITH p.parent_position_id = l_position_id
637: AND p.pos_structure_version_id =
638: (SELECT v.pos_structure_version_id
639: FROM per_pos_structure_versions v
640: WHERE v.position_structure_id = l_position_structure_id
641: AND l_effective_date
642: BETWEEN v.date_from
643: AND NVL(v.date_to, to_date('31-12-4712','dd-mm-yyyy')))

Line 698: FROM per_pos_structure_versions v

694: FROM per_pos_structure_elements p
695: START WITH p.parent_position_id = l_position_id
696: AND p.pos_structure_version_id =
697: (SELECT v.pos_structure_version_id
698: FROM per_pos_structure_versions v
699: WHERE v.position_structure_id = l_position_structure_id
700: AND l_effective_date
701: BETWEEN v.date_from
702: AND NVL(v.date_to, to_date('31-12-4712','dd-mm-yyyy')))