DBA Data[Home] [Help]

APPS.PQP_NL_PGGM_FUNCTIONS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1304: FROM pay_element_entry_values_f EEV,

1300: ,c_effective_date IN DATE) IS
1301: select min (fffunc.cn(decode(
1302: decode(INPUTV.uom,'M','N','N','N','I','N',null),'N',decode(INPUTV.hot_default_flag,'Y',nvl(EEV.screen_entry_value,
1303: nvl(LIV.default_value,INPUTV.default_value)),'N',EEV.screen_entry_value),null))) eoy_or
1304: FROM pay_element_entry_values_f EEV,
1305: pay_element_entries_f EE,
1306: pay_link_input_values_f LIV,
1307: pay_input_values_f INPUTV,
1308: pay_element_types_f pet

Line 1338: FROM pay_element_entry_values_f EEV,

1334: ,c_effective_date IN DATE) IS
1335: select min (fffunc.cn(decode(
1336: decode(INPUTV.uom,'M','N','N','N','I','N',null),'N',decode(INPUTV.hot_default_flag,'Y',nvl(EEV.screen_entry_value,
1337: nvl(LIV.default_value,INPUTV.default_value)),'N',EEV.screen_entry_value),null))) ha_or
1338: FROM pay_element_entry_values_f EEV,
1339: pay_element_entries_f EE,
1340: pay_link_input_values_f LIV,
1341: pay_input_values_f INPUTV,
1342: pay_element_types_f pet