APPS.GHR_NFC_POSITION_EXTRACTS dependencies on GHR_PA_HISTORY

Line 1784: c_eff_start_date ghr_pa_history.effective_date%type,

1780: AND hap.effective_start_date <= p_eff_dt
1781: ORDER BY hap.effective_start_date asc;
1782:
1783: CURSOR c_avbl_status_history(c_position_id hr_all_positions_f.position_id%type,
1784: c_eff_start_date ghr_pa_history.effective_date%type,
1785: c_eff_end_date ghr_pa_history.effective_date%type)
1786: IS
1787: SELECT 1
1788: FROM ghr_pa_history hist

Line 1785: c_eff_end_date ghr_pa_history.effective_date%type)

1781: ORDER BY hap.effective_start_date asc;
1782:
1783: CURSOR c_avbl_status_history(c_position_id hr_all_positions_f.position_id%type,
1784: c_eff_start_date ghr_pa_history.effective_date%type,
1785: c_eff_end_date ghr_pa_history.effective_date%type)
1786: IS
1787: SELECT 1
1788: FROM ghr_pa_history hist
1789: WHERE hist.information1 = to_char(c_position_id)

Line 1788: FROM ghr_pa_history hist

1784: c_eff_start_date ghr_pa_history.effective_date%type,
1785: c_eff_end_date ghr_pa_history.effective_date%type)
1786: IS
1787: SELECT 1
1788: FROM ghr_pa_history hist
1789: WHERE hist.information1 = to_char(c_position_id)
1790: AND hist.table_name = 'HR_ALL_POSITIONS_F'
1791: AND (hist.effective_date BETWEEN c_eff_start_date AND c_eff_end_date
1792: OR TRUNC(hist.process_date) BETWEEN TRUNC(c_eff_start_date) AND TRUNC(c_eff_end_date))

Line 1794: SELECT 1 FROM ghr_pa_history hist1

1790: AND hist.table_name = 'HR_ALL_POSITIONS_F'
1791: AND (hist.effective_date BETWEEN c_eff_start_date AND c_eff_end_date
1792: OR TRUNC(hist.process_date) BETWEEN TRUNC(c_eff_start_date) AND TRUNC(c_eff_end_date))
1793: AND EXISTS(
1794: SELECT 1 FROM ghr_pa_history hist1
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