eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_NFC_POSITION_EXTRACTS dependencies on HR_GENERAL

Line 1750: ,HR_GENERAL.DECODE_AVAILABILITY_STATUS(hap.availability_status_id) status

1746: CURSOR c_get_position (cp_eff_date DATE) IS
1747: SELECT hap.effective_start_date
1748: ,hap.effective_end_date
1749: ,permanent_temporary_flag
1750: ,HR_GENERAL.DECODE_AVAILABILITY_STATUS(hap.availability_status_id) status
1751: ,hap.location_id
1752: FROM hr_all_positions_f hap
1753: WHERE cp_eff_date BETWEEN hap.effective_start_date
1754: AND hap.effective_end_date

Line 1776: ,HR_GENERAL.DECODE_AVAILABILITY_STATUS(hap.availability_status_id) status

1772: CURSOR c_get_position_rec (p_eff_dt DATE) IS
1773: SELECT hap.effective_start_date st_date
1774: ,hap.effective_end_date e_date
1775: ,hap.creation_date
1776: ,HR_GENERAL.DECODE_AVAILABILITY_STATUS(hap.availability_status_id) status
1777: FROM hr_all_positions_f hap
1778: WHERE hap.position_id=p_position_id
1779: AND hap.business_group_id = p_business_group_id
1780: AND hap.effective_start_date <= p_eff_dt

Line 1799: AND HR_GENERAL.DECODE_AVAILABILITY_STATUS(hist1.information24) = 'Eliminated') ;

1795: WHERE hist1.information1 = to_char(c_position_id)
1796: AND hist1.table_name = 'HR_ALL_POSITIONS_F'
1797: AND hist1.effective_date > hist.effective_date
1798: and hist.pa_history_id > hist1.pa_history_id
1799: AND HR_GENERAL.DECODE_AVAILABILITY_STATUS(hist1.information24) = 'Eliminated') ;
1800:
1801:
1802: l_function_code VARCHAR2(1);
1803: l_active_inactive VARCHAR2(1);