DBA Data[Home] [Help]

APPS.PAY_DK_SICKNESS_DP202 dependencies on FND_NUMBER

Line 352: -- l_pay := TRIM(TO_CHAR(ROUND(NVL(FND_NUMBER.canonical_to_number(l_pay),0),2),'999G999G990D99'));

348: last_pay(p_business_group_id,asg_rec.asg_id,l_end_date,l_pay,l_period_type);
349: END IF ;
350:
351: -- l_pay := TRIM(TO_CHAR(ROUND(l_pay,2),'99g99g99g990d99','NLS_NUMERIC_CHARACTERS = '',.'''));
352: -- l_pay := TRIM(TO_CHAR(ROUND(NVL(FND_NUMBER.canonical_to_number(l_pay),0),2),'999G999G990D99'));
353: l_pay := TRIM(TO_CHAR(ROUND(FND_NUMBER.canonical_to_number(l_pay),2),'999G999G990D99'));
354:
355: /*The employee's pay condition*/
356: /* Changes for Lunar Payroll*/

Line 353: l_pay := TRIM(TO_CHAR(ROUND(FND_NUMBER.canonical_to_number(l_pay),2),'999G999G990D99'));

349: END IF ;
350:
351: -- l_pay := TRIM(TO_CHAR(ROUND(l_pay,2),'99g99g99g990d99','NLS_NUMERIC_CHARACTERS = '',.'''));
352: -- l_pay := TRIM(TO_CHAR(ROUND(NVL(FND_NUMBER.canonical_to_number(l_pay),0),2),'999G999G990D99'));
353: l_pay := TRIM(TO_CHAR(ROUND(FND_NUMBER.canonical_to_number(l_pay),2),'999G999G990D99'));
354:
355: /*The employee's pay condition*/
356: /* Changes for Lunar Payroll*/
357: IF l_period_type in ('Calendar Month','Lunar Month') THEN