APPS.PAY_MX_FF_UDFS dependencies on PAY_ELEMENT_ENTRIES_F

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

988: and hou.organization_id = hoi.organization_id
989: and cp_eff_date between hou.date_from and nvl(hou.date_to,cp_eff_date) ;
990:
991: -- cursor to get the IDW factor table name
992: CURSOR c_get_idw_factor_tab_name (cp_asg_id pay_element_entries_f.assignment_id%TYPE,
993: cp_eff_date DATE )
994: IS
995: select hrl.lookup_code
996: ,hrl.meaning

Line 999: pay_element_entries_f pee,

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