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.PQP_GB_SCOTLAND_LGPS_PENSIONPY dependencies on PQP_RATES_HISTORY_CALC

Line 359: --For the element to get processed by pqp_rates_history_calc.get_historic_rate two rows should be present

355: AND v_assignment_eff_date between peef.EFFECTIVE_START_DATE and peef.EFFECTIVE_END_DATE
356: AND v_assignment_eff_date between petf.EFFECTIVE_START_DATE and petf.EFFECTIVE_END_DATE;
357: --6666135 End
358:
359: --For the element to get processed by pqp_rates_history_calc.get_historic_rate two rows should be present
360: --One row with data PQP_UK_RATE_TYPE and PQP_LGPS_SCOTLAND_PENSION_PAY
361: --and second row with PQP_UK_ELEMENT_ATTRIBUTION and Pay Value.
362: -- 7369484 Start Changes made in cursor to fetch both rate types
363: CURSOR c2_PQP_UK_RATE_TYPE(n_element_type_id NUMBER)

Line 792: l_lgps_pensionable_pay:=pqp_rates_history_calc.get_historic_rate(p_assignment_id => c_all_assignments.assignment_id

788: IF (b_rate_type and b_input_value_present)
789: THEN
790: --6813970 end
791: Begin
792: l_lgps_pensionable_pay:=pqp_rates_history_calc.get_historic_rate(p_assignment_id => c_all_assignments.assignment_id
793: ,p_rate_name => 'LGPS Scotland Pensionable Pay'
794: ,p_effective_date => v_assignment_eff_date --v_eff_start_date
795: ,p_time_dimension => 'A'
796: ,p_rate_type_or_element => 'R');