DBA Data[Home] [Help]

APPS.HR_MEE_VIEWS_GEN dependencies on PER_POSITION_DEFINITIONS

Line 1694: per_position_definitions ppd

1690: ppd.segment28,
1691: ppd.segment29,
1692: ppd.segment30
1693: FROM hr_all_positions_f_vl pp,
1694: per_position_definitions ppd
1695: WHERE pp.position_definition_id = ppd.position_definition_id
1696: AND pp.position_id = p_position_id
1697: AND p_effective_date BETWEEN pp.effective_start_date
1698: AND pp.effective_end_date;

Line 1711: --from per_position_definitions.

1707:
1708: BEGIN
1709:
1710: --First Get the name from per_positions and all the segments
1711: --from per_position_definitions.
1712: --The name will be returned if no profiles are used.
1713: FOR segment_rec IN lc_get_position_details(p_position_id => p_position_id)
1714: LOOP
1715: ltt_segment(0).value := segment_rec.name;