43: pec.classification_id,
44: pec1.classification_name
45: FROM
46: pay_element_classifications pec ,
47: pay_element_classifications_tl pec1 ,
48: pay_element_types_f pat
49: WHERE
50: pec.legislation_code = 'NL'
51: AND pec.parent_classification_id IS NULL
80: pay_time_definitions ptd1,
81: pay_time_definitions ptd2,
82: pay_element_types_f pat1,
83: pay_retro_components prc,
84: pay_element_classifications_tl pec
85:
86: WHERE
87: pat.business_group_id = c_bg_id
88: AND c_eff_date between pat.effective_start_date AND pat.effective_end_date