APPS.PAY_MX_FF_UDFS dependencies on PAY_INPUT_VALUES_F

Line 980: pay_input_values_f piv,

976: cp_eff_date DATE)
977: IS
978: select nvl(FND_DATE.CANONICAL_TO_DATE(pev.SCREEN_ENTRY_VALUE),hr_general.end_of_time)
979: from pay_element_types_f pet,
980: pay_input_values_f piv,
981: pay_element_entries_f pee,
982: pay_element_entry_values_f pev
983: where pet.element_name='Integrated Daily Wage'
984: and piv.element_type_id = pet.element_type_id

Line 1001: pay_input_values_f piv,

997: cp_eff_date DATE)
998: IS
999: select nvl(FND_NUMBER.CANONICAL_TO_NUMBER(pev.SCREEN_ENTRY_VALUE),0)
1000: from pay_element_types_f pet,
1001: pay_input_values_f piv,
1002: pay_element_entries_f pee,
1003: pay_element_entry_values_f pev
1004: where pet.element_name='Integrated Daily Wage'
1005: and piv.element_type_id = pet.element_type_id

Line 1150: pay_input_values_f piv,

1146: IS
1147: select hrl.lookup_code
1148: ,hrl.meaning
1149: from pay_element_types_f pet,
1150: pay_input_values_f piv,
1151: pay_element_entries_f pee,
1152: pay_element_entry_values_f pev,
1153: hr_lookups hrl
1154: where pet.element_name='Integrated Daily Wage'

Line 1189: ln_idw_inp_id pay_input_values_f.input_value_id%TYPE;

1185: ln_variable_idw NUMBER;
1186: ln_last_idw_action pay_assignment_actions.assignment_action_id%TYPE;
1187: ln_asg_tuid pay_assignment_actions.tax_unit_id%TYPE;
1188: ln_idw_ele_id pay_element_types_f.element_type_id%TYPE;
1189: ln_idw_inp_id pay_input_values_f.input_value_id%TYPE;
1190: lb_gre_ambiguous BOOLEAN;
1191: lb_gre_missing BOOLEAN;
1192: lv_period_type pay_all_payrolls_f.period_type%TYPE;
1193: lv_contract_name VARCHAR2(240);

Line 1449: pay_input_values_f iv

1445: input_value_id
1446: INTO ln_idw_ele_id,
1447: ln_idw_inp_id
1448: FROM pay_element_types_f et,
1449: pay_input_values_f iv
1450: WHERE element_name = 'Integrated Daily Wage'
1451: AND et.legislation_code = 'MX'
1452: AND p_effective_date BETWEEN et.effective_start_date
1453: AND et.effective_end_date