DBA Data[Home] [Help]

APPS.PQP_GB_PCSPS_PENSIONPAY dependencies on PQP_RATES_HISTORY_CALC

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

392: AND v_assignment_eff_date between peef.EFFECTIVE_START_DATE and peef.EFFECTIVE_END_DATE
393: AND v_assignment_eff_date between petf.EFFECTIVE_START_DATE and petf.EFFECTIVE_END_DATE;
394: --6666135 End
395:
396: --For the element to get processed by pqp_rates_history_calc.get_historic_rate two rows should be present
397: --One row with data PQP_UK_RATE_TYPE and PQP_PCSPS_PENSION_PAY
398: --and second row with PQP_UK_ELEMENT_ATTRIBUTION and Pay Value.
399: -- --7369484 Begin Cursor including Scottish LGPS Rate Type
400: CURSOR c2_PQP_UK_RATE_TYPE(n_element_type_id NUMBER)

Line 869: l_lgps_pensionable_pay:=pqp_rates_history_calc.get_historic_rate_gb_pcsps(p_assignment_id => c_all_assignments.assignment_id

865: IF (b_rate_type and b_input_value_present)
866: THEN
867: --6813970 end
868: Begin
869: l_lgps_pensionable_pay:=pqp_rates_history_calc.get_historic_rate_gb_pcsps(p_assignment_id => c_all_assignments.assignment_id
870: ,p_rate_name => 'PCSPS Pensionable Pay'
871: ,p_effective_date => v_assignment_eff_date --v_eff_start_date
872: ,p_time_dimension => 'A'
873: ,p_rate_type_or_element => 'R');