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 373: --For the element to get processed by pqp_rates_history_calc.get_historic_rate two rows should be present

369: AND v_assignment_eff_date between peef.EFFECTIVE_START_DATE and peef.EFFECTIVE_END_DATE
370: AND v_assignment_eff_date between petf.EFFECTIVE_START_DATE and petf.EFFECTIVE_END_DATE;
371: --6666135 End
372:
373: --For the element to get processed by pqp_rates_history_calc.get_historic_rate two rows should be present
374: --One row with data PQP_UK_RATE_TYPE and PQP_LGPS_SCOTLAND_PENSION_PAY
375: --and second row with PQP_UK_ELEMENT_ATTRIBUTION and Pay Value.
376: -- 7369484 Start Changes made in cursor to fetch both rate types
377: CURSOR c2_PQP_UK_RATE_TYPE(n_element_type_id NUMBER)

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

802: IF (b_rate_type and b_input_value_present)
803: THEN
804: --6813970 end
805: Begin
806: l_lgps_pensionable_pay:=pqp_rates_history_calc.get_historic_rate(p_assignment_id => c_all_assignments.assignment_id
807: ,p_rate_name => 'LGPS Scotland Pensionable Pay'
808: ,p_effective_date => v_assignment_eff_date --v_eff_start_date
809: ,p_time_dimension => 'A'
810: ,p_rate_type_or_element => 'R');