DBA Data[Home] [Help]

APPS.PAY_MX_FF_UDFS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 982: pay_element_entry_values_f pev

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'
986: and pee.element_type_id = pet.element_type_id

Line 1003: pay_element_entry_values_f pev

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'
1007: and pee.element_type_id = pet.element_type_id

Line 1152: pay_element_entry_values_f pev,

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
1156: and piv.name ='IDW Factor Table'