DBA Data[Home] [Help]

APPS.GHR_PAY_CAPS dependencies on HR_POSITIONS_F

Line 148: p_org_id IN hr_positions_f.organization_id%TYPE,

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

Line 453: SELECT ORGANIZATION_ID FROM HR_POSITIONS_F

449: ---
450: CURSOR cur_get_pos_org(p_pos_id per_positions.position_id%TYPE,
451: p_eff_Date ghr_pa_requests.effective_date%TYPE)
452: IS
453: SELECT ORGANIZATION_ID FROM HR_POSITIONS_F
454: WHERE position_id=p_pos_id
455: AND p_eff_date between effective_start_Date and effective_end_date;
456: --
457: l_business_group_id per_positions.organization_id%TYPE;