APPS.PAY_MULTIASG dependencies on FFFUNC

Line 97: SELECT MIN (fffunc.cn(decode(decode(INPUTV.uom,'M','N','N','N','I','N',null),'N',

93: AND p_date_earned BETWEEN ASG1.effective_start_date
94: AND ASG1.effective_end_date;
95:
96: CURSOR periodic_salary (p_assign_id NUMBER) IS
97: SELECT MIN (fffunc.cn(decode(decode(INPUTV.uom,'M','N','N','N','I','N',null),'N',
98: decode(INPUTV.hot_default_flag,'Y',nvl(EEV.screen_entry_value,
99: nvl(LIV.default_value,INPUTV.default_value)),'N',EEV.screen_entry_value),null)))
100: FROM
101: pay_element_entry_values_f EEV,

Line 200: SELECT min (fffunc.cn(decode(

196: AND INPUTV.legislation_code = 'CA';
197:
198:
199: CURSOR rate (p_assign_id NUMBER) IS
200: SELECT min (fffunc.cn(decode(
201: decode(INPUTV.uom,'M','N','N','N','I','N',null),'N',decode(INPUTV.hot_default_flag,'Y',nvl(EEV.screen_entry_value,nvl(LIV.default_value,INPUTV.default_value)),'N',EEV.screen_entry_value),null)))
202: FROM
203: pay_element_entry_values_f EEV,
204: pay_element_entries_f EE,

Line 578: regular_earnings := fffunc.round_up ( (chk_hourly_rate * to_number(v_hours)),2);

574:
575: FETCH hours
576: INTO v_hours;
577:
578: regular_earnings := fffunc.round_up ( (chk_hourly_rate * to_number(v_hours)),2);
579:
580: -- ELSE
581: -- mesg := 'Rate Code not found in WAGE RATES table';
582: END IF;

Line 623: regular_earnings := fffunc.round_up ((chk_hourly_rate * to_number(v_hours)),2);

619:
620: FETCH hours
621: INTO v_hours;
622:
623: regular_earnings := fffunc.round_up ((chk_hourly_rate * to_number(v_hours)),2);
624:
625: END IF;
626:
627: