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 979: from pay_element_types_f pet,

975: CURSOR c_get_var_expiration_date (cp_asg_id pay_element_entries_f.assignment_id%TYPE,
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'

Line 1000: from pay_element_types_f pet,

996: CURSOR c_get_variable_idw_value (cp_asg_id pay_element_entries_f.assignment_id%TYPE,
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'

Line 1149: from pay_element_types_f pet,

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

Line 1188: ln_idw_ele_id pay_element_types_f.element_type_id%TYPE;

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

Line 1448: FROM pay_element_types_f et,

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