DBA Data[Home] [Help]

APPS.PAY_DK_SICKNESS_DP201 dependencies on FND_NUMBER

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

587: ELSE
588: last_pay(p_business_group_id,asg_rec.asg_id,l_end_date,l_pay);
589: END IF ;
590: --l_pay := TRIM(TO_CHAR(ROUND(l_pay,2),'99g99g99g990d99','NLS_NUMERIC_CHARACTERS = '',.'''));
591: --l_pay := TRIM(TO_CHAR(ROUND(NVL(FND_NUMBER.canonical_to_number(l_pay),0),2),'999G999G990D99'));
592: l_pay := TRIM(TO_CHAR(ROUND(FND_NUMBER.canonical_to_number(l_pay),2),'999G999G990D99'));
593: /*The employee's pay condition*/
594: /* Changes for Lunar Payroll*/
595: IF (asg_rec.period_type in ('Calendar Month','Lunar Month')) THEN

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

588: last_pay(p_business_group_id,asg_rec.asg_id,l_end_date,l_pay);
589: END IF ;
590: --l_pay := TRIM(TO_CHAR(ROUND(l_pay,2),'99g99g99g990d99','NLS_NUMERIC_CHARACTERS = '',.'''));
591: --l_pay := TRIM(TO_CHAR(ROUND(NVL(FND_NUMBER.canonical_to_number(l_pay),0),2),'999G999G990D99'));
592: l_pay := TRIM(TO_CHAR(ROUND(FND_NUMBER.canonical_to_number(l_pay),2),'999G999G990D99'));
593: /*The employee's pay condition*/
594: /* Changes for Lunar Payroll*/
595: IF (asg_rec.period_type in ('Calendar Month','Lunar Month')) THEN
596: xml_tab(xml_ctr).tagname := 'sal_per_month';