eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_PAY_CAPS dependencies on GHR_PA_REQUESTS

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

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

Line 148: p_pay_plan IN ghr_pa_Requests.from_pay_plan%TYPE,

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

Line 149: p_effective_date IN ghr_pa_Requests.effective_date%TYPE)

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

Line 167: p_agency_code ghr_pa_Requests.agency_code%TYPE,

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

Line 179: p_agency_sub_code ghr_pa_Requests.agency_code%TYPE,

175: AND p_eff_date BETWEEN cert_start_date AND nvl(cert_end_date,to_date('31/12/4712','DD/MM/YYYY') )
176: AND ( INSTR(cert_group,p_pay_plan) > 0 );
177: --
178: CURSOR cur_perf_cert_agency_sub(p_eff_date date,
179: p_agency_sub_code ghr_pa_Requests.agency_code%TYPE,
180: p_pay_plan ghr_pay_plans.pay_plan%TYPE)
181: IS
182: SELECT cert_group
183: FROM ghr_perf_cert

Line 211: l_from_Other_pay ghr_pa_requests.to_other_pay_amount%TYPE;

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

Line 291: p_effective_date IN ghr_pa_Requests.effective_date%TYPE)

287:
288: function pay_cap_chk_ttl_38(l_user_table_id IN pay_user_tables.user_table_id%TYPE,
289: l_user_clomun_name IN pay_user_columns.user_column_name%TYPE,
290: l_market_pay IN number,
291: p_effective_date IN ghr_pa_Requests.effective_date%TYPE)
292: RETURN BOOLEAN IS
293: CURSOR range_values is
294: SELECT udr.row_low_range_or_name,udr.row_high_range
295: FROM pay_user_columns udc,

Line 433: p_eff_Date ghr_pa_requests.effective_date%TYPE)

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