APPS.HR_MEE_VIEWS_GEN dependencies on PER_POSITION_DEFINITIONS

Line 1737: per_position_definitions ppd

1733: ppd.segment28,
1734: ppd.segment29,
1735: ppd.segment30
1736: FROM hr_all_positions_f_vl pp,
1737: per_position_definitions ppd
1738: WHERE pp.position_definition_id = ppd.position_definition_id
1739: AND pp.position_id = p_position_id
1740: AND p_effective_date BETWEEN pp.effective_start_date
1741: AND pp.effective_end_date;

Line 1754: --from per_position_definitions.

1750:
1751: BEGIN
1752:
1753: --First Get the name from per_positions and all the segments
1754: --from per_position_definitions.
1755: --The name will be returned if no profiles are used.
1756: FOR segment_rec IN lc_get_position_details(p_position_id => p_position_id)
1757: LOOP
1758: ltt_segment(0).value := segment_rec.name;