[Home] [Help]
195: AND NVL(business_group_id,p_business_group_id) = p_business_group_id;
196: --
197:
198: CURSOR cur_perf_cert_org(p_eff_date date,
199: p_org_id per_positions.organization_id%TYPE,
200: p_pay_plan ghr_pay_plans.pay_plan%TYPE,
201: p_business_group_id number)
202: IS
203: SELECT cert_group
220: --
221: ll_pay_plan ghr_pay_plans.pay_plan%TYPE;
222: l_from_Other_pay ghr_pa_requests.to_other_pay_amount%TYPE;
223: l_cert_group ghr_perf_cert.cert_group%type;
224: l_business_group_id per_positions.organization_id%TYPE;
225: --
226: -- PERFORMANCE CERTIFICATION CURSOR DECLARATIONS END HERE
227: --
228: --- New Variables End.
446: and asg.effective_end_date
447: and asg.primary_flag = 'Y';
448:
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
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;
458: l_agency_subele_code per_position_definitions.segment4%TYPE;
459: l_org_id per_positions.organization_id%TYPE;
460: --Bug 13414643,13403289
461: CURSOR get_locality_pay_area
455: AND p_eff_date between effective_start_Date and effective_end_date;
456: --
457: l_business_group_id per_positions.organization_id%TYPE;
458: l_agency_subele_code per_position_definitions.segment4%TYPE;
459: l_org_id per_positions.organization_id%TYPE;
460: --Bug 13414643,13403289
461: CURSOR get_locality_pay_area
462: IS
463: SELECT lc.locality_pay_area_code