DBA Data[Home] [Help]

APPS.PQP_NL_PENSION_TEMPLATE dependencies on FND_NUMBER

Line 1414: ,fnd_number.number_to_canonical(r_pty_rec.ee_contribution_percent)

1410: AND r_pty_rec.salary_calculation_method = '3' THEN
1411: IF NVL(r_pty_rec.annual_premium_amount,0) > 0 THEN
1412: Update_Ipval_Defval( p_scheme_prefix||' Pension Deduction'
1413: ,'Percentage'
1414: ,fnd_number.number_to_canonical(r_pty_rec.ee_contribution_percent)
1415: ,p_business_group_id);
1416: Update_Ipval_Defval( p_scheme_prefix||' Pension Deduction'
1417: ,'Fixed Premium Amount'
1418: ,fnd_number.number_to_canonical(r_pty_rec.annual_premium_amount)

Line 1418: ,fnd_number.number_to_canonical(r_pty_rec.annual_premium_amount)

1414: ,fnd_number.number_to_canonical(r_pty_rec.ee_contribution_percent)
1415: ,p_business_group_id);
1416: Update_Ipval_Defval( p_scheme_prefix||' Pension Deduction'
1417: ,'Fixed Premium Amount'
1418: ,fnd_number.number_to_canonical(r_pty_rec.annual_premium_amount)
1419: ,p_business_group_id);
1420: END IF;
1421: ELSIF p_deduction_method = 'PE' THEN
1422: IF NVL(r_pty_rec.ee_contribution_percent,0) > 0 THEN

Line 1425: ,fnd_number.number_to_canonical(r_pty_rec.ee_contribution_percent)

1421: ELSIF p_deduction_method = 'PE' THEN
1422: IF NVL(r_pty_rec.ee_contribution_percent,0) > 0 THEN
1423: Update_Ipval_Defval( p_scheme_prefix||' Pension Deduction'
1424: ,'Percentage'
1425: ,fnd_number.number_to_canonical(r_pty_rec.ee_contribution_percent)
1426: ,p_business_group_id);
1427: END IF;
1428:
1429: IF (NVL(r_pty_rec.er_contribution_percent,0) > 0

Line 1434: ,fnd_number.number_to_canonical(r_pty_rec.er_contribution_percent)

1430: AND p_employer_component = 'Y'
1431: AND l_configuration_information7 = 'Y' ) THEN
1432: Update_Ipval_Defval( p_scheme_prefix||' Employer Pension Contribution'
1433: ,'Percentage'
1434: ,fnd_number.number_to_canonical(r_pty_rec.er_contribution_percent)
1435: ,p_business_group_id);
1436: END IF;
1437: END IF;
1438: CLOSE csr_pty1;