DBA Data[Home] [Help]

APPS.PQP_GB_LGPS_PENSIONPAY dependencies on PQP_RATES_HISTORY_CALC

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

353: AND v_assignment_eff_date between peef.EFFECTIVE_START_DATE and peef.EFFECTIVE_END_DATE
354: AND v_assignment_eff_date between petf.EFFECTIVE_START_DATE and petf.EFFECTIVE_END_DATE;
355: --6666135 End
356:
357: --For the element to get processed by pqp_rates_history_calc.get_historic_rate two rows should be present
358: --One row with data PQP_UK_RATE_TYPE and PQP_LGPS_PENSION_PAY
359: --and second row with PQP_UK_ELEMENT_ATTRIBUTION and Pay Value.
360: -- --7369484 Begin Cursor including Scottish LGPS Rate Type
361: CURSOR c2_PQP_UK_RATE_TYPE(n_element_type_id NUMBER)

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

781: IF (b_rate_type and b_input_value_present)
782: THEN
783: --6813970 end
784: Begin
785: l_lgps_pensionable_pay:=pqp_rates_history_calc.get_historic_rate(p_assignment_id => c_all_assignments.assignment_id
786: ,p_rate_name => 'LGPS Pensionable Pay'
787: ,p_effective_date => v_assignment_eff_date --v_eff_start_date
788: ,p_time_dimension => 'A'
789: ,p_rate_type_or_element => 'R');