DBA Data[Home] [Help]

APPS.PQP_GB_LGPS_PENSIONPAY dependencies on PQP_RATES_HISTORY_CALC

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

366: AND v_assignment_eff_date between peef.EFFECTIVE_START_DATE and peef.EFFECTIVE_END_DATE
367: AND v_assignment_eff_date between petf.EFFECTIVE_START_DATE and petf.EFFECTIVE_END_DATE;
368: --6666135 End
369:
370: --For the element to get processed by pqp_rates_history_calc.get_historic_rate two rows should be present
371: --One row with data PQP_UK_RATE_TYPE and PQP_LGPS_PENSION_PAY
372: --and second row with PQP_UK_ELEMENT_ATTRIBUTION and Pay Value.
373: -- --7369484 Begin Cursor including Scottish LGPS Rate Type
374: CURSOR c2_PQP_UK_RATE_TYPE(n_element_type_id NUMBER)

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

794: IF (b_rate_type and b_input_value_present)
795: THEN
796: --6813970 end
797: Begin
798: l_lgps_pensionable_pay:=pqp_rates_history_calc.get_historic_rate(p_assignment_id => c_all_assignments.assignment_id
799: ,p_rate_name => 'LGPS Pensionable Pay'
800: ,p_effective_date => v_assignment_eff_date --v_eff_start_date
801: ,p_time_dimension => 'A'
802: ,p_rate_type_or_element => 'R');