APPS.GHR_EHRI_DYNRPT dependencies on HR_ORGANIZATION_UNITS

Line 2409: FROM hr_organization_units

2405: CURSOR cur_prior_pos_org(p_position_id hr_positions_f.position_id%TYPE,
2406: p_eff_date ghr_pa_requests.effective_date%TYPE)
2407: IS
2408: SELECT name
2409: FROM hr_organization_units
2410: WHERE organization_id = ( SELECT organization_id
2411: FROM hr_positions_f
2412: WHERE position_id=p_position_id
2413: AND p_eff_date between effective_start_date and effective_end_date);

Line 2415: CURSOR cur_pos_org(p_org_id hr_organization_units.organization_id%TYPE,

2411: FROM hr_positions_f
2412: WHERE position_id=p_position_id
2413: AND p_eff_date between effective_start_date and effective_end_date);
2414: --
2415: CURSOR cur_pos_org(p_org_id hr_organization_units.organization_id%TYPE,
2416: p_eff_date ghr_pa_requests.effective_date%TYPE)
2417: IS
2418: SELECT name
2419: FROM hr_organization_units

Line 2419: FROM hr_organization_units

2415: CURSOR cur_pos_org(p_org_id hr_organization_units.organization_id%TYPE,
2416: p_eff_date ghr_pa_requests.effective_date%TYPE)
2417: IS
2418: SELECT name
2419: FROM hr_organization_units
2420: WHERE organization_id = p_org_id
2421: AND p_eff_date between date_from and NVL(date_to,to_Date('31/12/4712','DD/MM/YYYY'));
2422: --
2423: -- added date cond and other fields for ENW EHRI changes