DBA Data[Home] [Help]

APPS.PAY_IN_FF_PKG dependencies on PAY_INPUT_VALUES_F

Line 784: pay_input_values_f piv

780: SELECT count (*)
781: FROM pay_element_entry_values_f pev,
782: pay_element_entries_f pee,
783: pay_element_types_f pet,
784: pay_input_values_f piv
785: WHERE pet.element_name like 'Deduction under Section 80DD'
786: AND pet.legislation_code = 'IN'
787: AND pet.element_type_id = piv.element_type_id
788: AND piv.name = 'Disability Percentage'

Line 1357: From pay_input_values_f

1353:
1354: Cursor c_input_value_id
1355: IS
1356: Select input_value_id
1357: From pay_input_values_f
1358: Where element_type_id = p_element_type_id
1359: And p_date Between effective_start_date AND effective_end_date
1360: And name=p_input_value;
1361: