DBA Data[Home] [Help]

APPS.PAY_PYUCSLIS_PKG dependencies on PER_POS_STRUCTURE_VERSIONS

Line 703: FROM per_pos_structure_versions v

699: AND ol.security_profile_id= l_security_profile_id)
700: START WITH p.parent_position_id = l_position_id
701: AND p.pos_structure_version_id =
702: (SELECT v.pos_structure_version_id
703: FROM per_pos_structure_versions v
704: WHERE v.position_structure_id = l_position_structure_id
705: AND l_effective_date
706: BETWEEN v.date_from
707: AND NVL(v.date_to, to_date('31-12-4712','dd-mm-yyyy')))

Line 762: FROM per_pos_structure_versions v

758: FROM per_pos_structure_elements p
759: START WITH p.parent_position_id = l_position_id
760: AND p.pos_structure_version_id =
761: (SELECT v.pos_structure_version_id
762: FROM per_pos_structure_versions v
763: WHERE v.position_structure_id = l_position_structure_id
764: AND l_effective_date
765: BETWEEN v.date_from
766: AND NVL(v.date_to, to_date('31-12-4712','dd-mm-yyyy')))