[Home] [Help]
992: SELECT distinct PIV.name -- PIV.display_sequence
993: FROM --pay_element_types_f PET
994: pay_input_values_f PIV
995: ,pay_accrual_plans PAP
996: ,pay_net_calculation_rules PNCR
997: WHERE--PET.element_type_id = cp_element_type_id
998: --AND PET.element_type_id = PIV.element_type_id
999: PIV.element_type_id = cp_element_type_id
1000: AND cp_effective_date between PIV.effective_start_date