APPS.PQP_NL_PGGM_FUNCTIONS dependencies on FFFUNC

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

1143: -- Cursor to get the value for EOY Bonus override percent
1144: --
1145: CURSOR c_eoy_per_or (c_asg_id IN NUMBER
1146: ,c_effective_date IN DATE) IS
1147: select min (fffunc.cn(decode(
1148: decode(INPUTV.uom,'M','N','N','N','I','N',null),'N',decode(INPUTV.hot_default_flag,'Y',nvl(EEV.screen_entry_value,
1149: nvl(LIV.default_value,INPUTV.default_value)),'N',EEV.screen_entry_value),null))) eoy_or
1150: FROM pay_element_entry_values_f EEV,
1151: pay_element_entries_f EE,

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

1177: -- Cursor to get the value for Holiday Allowance override percent
1178: --
1179: CURSOR c_ha_per_or (c_asg_id IN NUMBER
1180: ,c_effective_date IN DATE) IS
1181: select min (fffunc.cn(decode(
1182: decode(INPUTV.uom,'M','N','N','N','I','N',null),'N',decode(INPUTV.hot_default_flag,'Y',nvl(EEV.screen_entry_value,
1183: nvl(LIV.default_value,INPUTV.default_value)),'N',EEV.screen_entry_value),null))) ha_or
1184: FROM pay_element_entry_values_f EEV,
1185: pay_element_entries_f EE,