APPS.GHR_PAY_CAPS dependencies on GHR_PA_REQUESTS

Line 147: FUNCTION perf_certified(p_agency_code IN ghr_pa_requests.from_Agency_code%TYPE,

143: --
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

Line 149: p_pay_plan IN ghr_pa_Requests.from_pay_plan%TYPE,

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
153: --

Line 150: p_effective_date IN ghr_pa_Requests.effective_date%TYPE)

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
153: --
154: -- Bug 4063133

Line 168: p_agency_code ghr_pa_Requests.agency_code%TYPE,

164: AND trunc(p_eff_date) between asg.effective_start_date
165: and asg.effective_end_date;
166: --
167: CURSOR cur_perf_cert_agency(p_eff_date date,
168: p_agency_code ghr_pa_Requests.agency_code%TYPE,
169: p_pay_plan ghr_pay_plans.pay_plan%TYPE,
170: p_business_group_id number)
171: IS
172: SELECT distinct cert_group

Line 183: p_agency_sub_code ghr_pa_Requests.agency_code%TYPE,

179: --Bug # 10272986 Added Business Group Id
180: AND NVL(business_group_id,p_business_group_id) = p_business_group_id;
181: --
182: CURSOR cur_perf_cert_agency_sub(p_eff_date date,
183: p_agency_sub_code ghr_pa_Requests.agency_code%TYPE,
184: p_pay_plan ghr_pay_plans.pay_plan%TYPE,
185: p_business_group_id number)
186: IS
187: SELECT cert_group

Line 222: l_from_Other_pay ghr_pa_requests.to_other_pay_amount%TYPE;

218: FROM ghr_pay_plans ppl
219: WHERE ppl.pay_plan = p_pay_plan;
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

Line 307: p_effective_date IN ghr_pa_Requests.effective_date%TYPE)

303:
304: function pay_cap_chk_ttl_38(l_user_table_id IN pay_user_tables.user_table_id%TYPE,
305: l_user_clomun_name IN pay_user_columns.user_column_name%TYPE,
306: l_market_pay IN number,
307: p_effective_date IN ghr_pa_Requests.effective_date%TYPE)
308: RETURN BOOLEAN IS
309: CURSOR range_values is
310: SELECT udr.row_low_range_or_name,udr.row_high_range
311: FROM pay_user_columns udc,

Line 451: p_eff_Date ghr_pa_requests.effective_date%TYPE)

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
455: AND p_eff_date between effective_start_Date and effective_end_date;

Line 488: l_psi := ghr_pa_requests_pkg.get_personnel_system_indicator(p_to_position_id, p_effective_date);

484: --
485: BEGIN
486: -- Bug#4758111 PRD 2 Processing. Skip Pay Cap calculation for the PRD 2.
487: --Bug# 8324201 added NSPS condition for PRD 2.
488: l_psi := ghr_pa_requests_pkg.get_personnel_system_indicator(p_to_position_id, p_effective_date);
489: -- Bug# 13103038 added prd2_process condition
490: --Bug 13414643,13403289
491: for rec_locality_pay_area in get_locality_pay_area
492: loop