eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_MX_FF_UDFS dependencies on PAY_ELEMENT_TYPES_F

Line 997: from pay_element_types_f pet,

993: cp_eff_date DATE )
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

Line 1036: ln_idw_ele_id pay_element_types_f.element_type_id%TYPE;

1032: ln_rate NUMBER;
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;

Line 1293: FROM pay_element_types_f et,

1289: SELECT iv.element_type_id,
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