1785: FCL.meaning
1786: INTO v_inpval_id,
1787: v_pay_basis
1788: FROM per_assignments_f ASG,
1789: per_pay_bases PYB,
1790: hr_lookups FCL
1791: WHERE FCL.lookup_code = PYB.pay_basis
1792: AND FCL.lookup_type = 'PAY_BASIS'
1793: AND FCL.application_id = 800
3064: BASES.pay_basis
3065: , INPUTV.input_value_id
3066: from
3067: per_all_assignments_f ASSIGN
3068: , per_pay_bases BASES
3069: , pay_input_values_f INPUTV
3070: , pay_element_types_f ETYPE
3071: , pay_rates RATE
3072: where l_date_earned BETWEEN ASSIGN.effective_start_date