DBA Data[Home] [Help]

APPS.PQP_NL_PGGM_FUNCTIONS dependencies on FFFUNC

Line 1301: select min (fffunc.cn(decode(

1297: -- Cursor to get the value for EOY Bonus override percent
1298: --
1299: CURSOR c_eoy_per_or (c_asg_id IN NUMBER
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,

Line 1335: select min (fffunc.cn(decode(

1331: -- Cursor to get the value for Holiday Allowance override percent
1332: --
1333: CURSOR c_ha_per_or (c_asg_id IN NUMBER
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,