DBA Data[Home] [Help]

APPS.PAY_MX_FF_UDFS dependencies on PAY_INPUT_VALUES_F

Line 998: pay_input_values_f piv,

994: IS
995: select hrl.lookup_code
996: ,hrl.meaning
997: from pay_element_types_f pet,
998: pay_input_values_f piv,
999: pay_element_entries_f pee,
1000: pay_element_entry_values_f pev,
1001: hr_lookups hrl
1002: where pet.element_name='Integrated Daily Wage'

Line 1037: ln_idw_inp_id pay_input_values_f.input_value_id%TYPE;

1033: ln_variable_idw NUMBER;
1034: ln_last_idw_action pay_assignment_actions.assignment_action_id%TYPE;
1035: ln_asg_tuid pay_assignment_actions.tax_unit_id%TYPE;
1036: ln_idw_ele_id pay_element_types_f.element_type_id%TYPE;
1037: ln_idw_inp_id pay_input_values_f.input_value_id%TYPE;
1038: lb_gre_ambiguous BOOLEAN;
1039: lb_gre_missing BOOLEAN;
1040: lv_period_type pay_all_payrolls_f.period_type%TYPE;
1041: lv_contract_name VARCHAR2(240);

Line 1294: pay_input_values_f iv

1290: input_value_id
1291: INTO ln_idw_ele_id,
1292: ln_idw_inp_id
1293: FROM pay_element_types_f et,
1294: pay_input_values_f iv
1295: WHERE element_name = 'Integrated Daily Wage'
1296: AND et.legislation_code = 'MX'
1297: AND p_effective_date BETWEEN et.effective_start_date
1298: AND et.effective_end_date