APPS.GHR_EHRI_DYNRPT dependencies on HR_ORGANIZATION_UNITS

Line 2563: FROM hr_organization_units

2559: CURSOR cur_prior_pos_org(p_position_id hr_positions_f.position_id%TYPE,
2560: p_eff_date ghr_pa_requests.effective_date%TYPE)
2561: IS
2562: SELECT name
2563: FROM hr_organization_units
2564: WHERE organization_id = ( SELECT organization_id
2565: FROM hr_positions_f
2566: WHERE position_id=p_position_id
2567: AND p_eff_date between effective_start_date and effective_end_date);

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

2565: FROM hr_positions_f
2566: WHERE position_id=p_position_id
2567: AND p_eff_date between effective_start_date and effective_end_date);
2568: --
2569: CURSOR cur_pos_org(p_org_id hr_organization_units.organization_id%TYPE,
2570: p_eff_date ghr_pa_requests.effective_date%TYPE)
2571: IS
2572: SELECT name
2573: FROM hr_organization_units

Line 2573: FROM hr_organization_units

2569: CURSOR cur_pos_org(p_org_id hr_organization_units.organization_id%TYPE,
2570: p_eff_date ghr_pa_requests.effective_date%TYPE)
2571: IS
2572: SELECT name
2573: FROM hr_organization_units
2574: WHERE organization_id = p_org_id
2575: AND p_eff_date between date_from and NVL(date_to,to_Date('31/12/4712','DD/MM/YYYY'));
2576: --
2577: -- added date cond and other fields for ENW EHRI changes