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_ENTRIES_F

Line 975: CURSOR c_get_var_expiration_date (cp_asg_id pay_element_entries_f.assignment_id%TYPE,

971: ln_variable_idw NUMBER;
972: ln_date_paid DATE;
973: ln_var_expiration_date DATE;
974:
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,

Line 981: pay_element_entries_f pee,

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
985: and piv.name ='Var Expiration Date'

Line 996: CURSOR c_get_variable_idw_value (cp_asg_id pay_element_entries_f.assignment_id%TYPE,

992: and cp_eff_date between pee.effective_start_date and pee.effective_end_date
993: and cp_eff_date between pev.effective_start_date and pev.effective_end_date ;
994:
995:
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,

Line 1002: pay_element_entries_f pee,

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
1006: and piv.name ='Variable IDW'

Line 1144: CURSOR c_get_idw_factor_tab_name (cp_asg_id pay_element_entries_f.assignment_id%TYPE,

1140: and hou.organization_id = hoi.organization_id
1141: and cp_eff_date between hou.date_from and nvl(hou.date_to,cp_eff_date) ;
1142:
1143: -- cursor to get the IDW factor table name
1144: CURSOR c_get_idw_factor_tab_name (cp_asg_id pay_element_entries_f.assignment_id%TYPE,
1145: cp_eff_date DATE )
1146: IS
1147: select hrl.lookup_code
1148: ,hrl.meaning

Line 1151: pay_element_entries_f pee,

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'
1155: and piv.element_type_id = pet.element_type_id