APPS.GHR_PAY_CAPS dependencies on PER_POSITIONS

Line 192: p_org_id per_positions.organization_id%TYPE,

188: AND ( INSTR(cert_group,p_pay_plan) > 0 );
189: --
190:
191: CURSOR cur_perf_cert_org(p_eff_date date,
192: p_org_id per_positions.organization_id%TYPE,
193: p_pay_plan ghr_pay_plans.pay_plan%TYPE)
194: IS
195: SELECT cert_group
196: FROM ghr_perf_cert

Line 213: l_business_group_id per_positions.organization_id%TYPE;

209: --
210: ll_pay_plan ghr_pay_plans.pay_plan%TYPE;
211: l_from_Other_pay ghr_pa_requests.to_other_pay_amount%TYPE;
212: l_cert_group ghr_perf_cert.cert_group%type;
213: l_business_group_id per_positions.organization_id%TYPE;
214: --
215: -- PERFORMANCE CERTIFICATION CURSOR DECLARATIONS END HERE
216: --
217: --- New Variables End.

Line 432: CURSOR cur_get_pos_org(p_pos_id per_positions.position_id%TYPE,

428: and asg.effective_end_date
429: and asg.primary_flag = 'Y';
430:
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

Line 439: l_business_group_id per_positions.organization_id%TYPE;

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;
440: l_agency_subele_code per_position_definitions.segment4%TYPE;
441: l_org_id per_positions.organization_id%TYPE;
442:
443: FUNCTION convert_amount_to_PA(p_amount IN NUMBER

Line 441: l_org_id per_positions.organization_id%TYPE;

437: AND p_eff_date between effective_start_Date and effective_end_date;
438: --
439: l_business_group_id per_positions.organization_id%TYPE;
440: l_agency_subele_code per_position_definitions.segment4%TYPE;
441: l_org_id per_positions.organization_id%TYPE;
442:
443: FUNCTION convert_amount_to_PA(p_amount IN NUMBER
444: ,p_pay_basis IN VARCHAR2)
445: RETURN NUMBER IS