DBA Data[Home] [Help]

APPS.GHR_PAY_CAPS dependencies on HR_POSITIONS_F

Line 147: p_org_id IN hr_positions_f.organization_id%TYPE,

143: --
144: -- PERFORMANCE CERTIFICATION FUNCTION DECLARATIONS START HERE
145: --
146: FUNCTION perf_certified(p_agency_code IN ghr_pa_requests.from_Agency_code%TYPE,
147: p_org_id IN hr_positions_f.organization_id%TYPE,
148: p_pay_plan IN ghr_pa_Requests.from_pay_plan%TYPE,
149: p_effective_date IN ghr_pa_Requests.effective_date%TYPE)
150: RETURN BOOLEAN
151: IS

Line 435: SELECT ORGANIZATION_ID FROM HR_POSITIONS_F

431: ---
432: CURSOR cur_get_pos_org(p_pos_id per_positions.position_id%TYPE,
433: p_eff_Date ghr_pa_requests.effective_date%TYPE)
434: IS
435: SELECT ORGANIZATION_ID FROM HR_POSITIONS_F
436: WHERE position_id=p_pos_id
437: AND p_eff_date between effective_start_Date and effective_end_date;
438: --
439: l_business_group_id per_positions.organization_id%TYPE;