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.PAY_FF_FUNCTIONS dependencies on PQP_CAR_MILEAGE_FUNCTIONS

Line 47: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid

43: begin
44: IF p_payroll_action_id IS NULL THEN
45: l_effective_date:=p_effective_date;
46: ELSE
47: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid
48: (p_payroll_action_id));
49: END IF;
50:
51: hr_utility.set_location('Start of GET_PQP_LIMIT', 5);

Line 124: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid

120:
121: Max_excl_allow number := 0;
122: l_effective_date date;
123: begin
124: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid
125: (p_payroll_action_id));
126: hr_utility.set_location('Start of Calc_max_excl_allow ', 5);
127: max_excl_allow := (0.20 * p_ee_incld_annual_comp * p_years_of_service) -
128: p_total_er_contr_prior_years;

Line 159: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid

155: l_effective_date date;
156:
157: begin
158:
159: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid
160: (p_payroll_action_id));
161: hr_utility.set_location('Start of Calc_overall_limit ', 5);
162:
163: l_incld_annual_comp_limit := pay_ff_functions.get_pqp_limit(

Line 213: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid

209: this_limit number := 0; -- Since the same name variable
210: -- is also used for pqp_limit
211: l_effective_date date; -- of the same name
212: begin
213: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid
214: (p_payroll_action_id));
215: hr_utility.set_location('Start of Calc_any_year_limit ', 5);
216: l_additional_any_year_amount := pay_ff_functions.get_pqp_limit(
217: p_payroll_action_id=>p_payroll_action_id,

Line 297: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid

293: AND service.date_start <= l_effective_date;
294:
295:
296: begin
297: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid
298: (p_payroll_action_id));
299: l_overall_er_limit :=
300: pay_ff_functions.get_pqp_limit (
301: p_payroll_action_id=>p_payroll_action_id,

Line 379: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid

375: amt3 number := 0;
376: l_effective_date date;
377: begin
378:
379: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid
380: (p_payroll_action_id));
381: l_elec_def_catchup_limit :=
382: pay_ff_functions.get_pqp_limit (
383: p_payroll_action_id=>p_payroll_action_id,

Line 448: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid

444: AND ass.person_id = service.person_id
445: AND service.date_start <= l_effective_date;
446:
447: begin
448: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid
449: (p_payroll_action_id));
450: for c1_rec in c1
451: loop
452: p_start_date := c1_rec.start_date;

Line 499: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid

495: and c.prtt_enrt_rslt_stat_cd is null;
496:
497: begin
498:
499: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid
500: (p_payroll_action_id));
501: for c_person_rec in c_person
502: loop
503: l_person_id := c_person_rec.person_id;

Line 566: p_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid

562: AND nvl(ass.effective_end_date, l_effective_date)
563: AND ass.assignment_id = p_assignment_id;
564:
565: BEGIN
566: p_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid
567: (p_payroll_action_id));
568: /*
569: * make use of the day and month that the user has passed from the formula else
570: * use the context date

Line 619: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid

615: begin
616: IF p_payroll_action_id IS NULL THEN
617: l_effective_date:=p_effective_date;
618: ELSE
619: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid
620: (p_payroll_action_id));
621: END IF;
622: hr_utility.set_location('Start of GET_457_LIMIT', 5);
623:

Line 690: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid

686: group by contr.date_to;
687:
688: begin
689:
690: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid
691: (p_payroll_action_id));
692: for c1_rec in c1
693: loop
694: l_amt := c1_rec.amt;

Line 713: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid

709:
710: l_calc_457_limit number := 0;
711: l_effective_date date;
712: begin
713: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid
714: (p_payroll_action_id));
715: hr_utility.set_location('Start of get_457_calc_limit ', 5);
716:
717: l_calc_457_limit := (p_ee_incld_annual_comp / 3) ;

Line 734: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid

730: p_dummy in varchar)
731: return number is
732: l_effective_date date;
733: begin
734: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid
735: (p_payroll_action_id));
736: hr_utility.set_location('Start of get_457_vested_amt ', 5);
737:
738: return 0;

Line 756: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid

752: p_dummy in varchar)
753: return number is
754: l_effective_date date;
755: begin
756: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid
757: (p_payroll_action_id));
758: hr_utility.set_location('Start of Run Year ', 5);
759: return to_number(to_char(l_effective_date,'YYYY'));
760: hr_utility.set_location('End of Run Year ', 10);