eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NL_ABP_ARCHIVE dependencies on FND_NUMBER

Line 196: ,sum(fnd_number.canonical_to_number(peev.screen_entry_value)) contr_amt

192: SELECT pei.eei_information12 sub_cat
193: ,pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id) date_earned
194: ,decode (pei.eei_information12,'FPU_B','VPL','PPP','PPP-I','OPNP-I') pension_type
195: ,decode (pei.eei_information12,'OPNP_65','A','OPNP_W25','B','OPNP_W50','C') pension_type_variant
196: ,sum(fnd_number.canonical_to_number(peev.screen_entry_value)) contr_amt
197: ,pty.ee_contribution_bal_type_id
198: ,pty.er_contribution_bal_type_id
199: FROM pay_element_type_extra_info pei,
200: pay_element_types_f pet,

Line 278: SELECT fnd_number.canonical_to_number(pai.action_information7) contr_base

274: -- ==============================================================
275: CURSOR csr_prev_basis_amt (c_assignment_id IN NUMBER
276: ,c_effective_date IN DATE
277: ,c_pension_type IN VARCHAR2) IS
278: SELECT fnd_number.canonical_to_number(pai.action_information7) contr_base
279: FROM pay_action_information pai
280: WHERE pai.action_information_category = 'NL_ABP_PENSION_INFO'
281: AND pai.action_context_type = 'AAP'
282: AND pai.assignment_id = c_assignment_id

Line 742: ,fnd_number.canonical_to_number (nvl (target.segment29

738: ,decode (asg.effective_end_date
739: ,hr_general.end_of_time
740: ,trunc (c_period_end_date)
741: ,asg.effective_end_date) end_date
742: ,fnd_number.canonical_to_number (nvl (target.segment29
743: ,'100')) ptp
744: FROM per_assignments_f asg
745: ,per_assignment_status_types past
746: ,hr_soft_coding_keyflex target

Line 1075: SELECT nvl (sum (round (fnd_number.canonical_to_number (peev.screen_entry_value)

1071: ,c_orig_st_date IN DATE
1072: ,c_orig_ed_date IN DATE
1073: ,c_ele_type_id IN NUMBER
1074: ,c_input_val_id IN NUMBER ) IS
1075: SELECT nvl (sum (round (fnd_number.canonical_to_number (peev.screen_entry_value)
1076: ,2))
1077: ,0) prior_ptp
1078: FROM pay_element_entries_f peef
1079: ,pay_element_links_f pelf

Line 1198: ,least(fnd_number.canonical_to_number (nvl (target.segment29

1194: ,c_end_date IN DATE) IS
1195: SELECT DISTINCT
1196: asg.effective_start_date start_date
1197: ,asg.effective_end_date end_date
1198: ,least(fnd_number.canonical_to_number (nvl (target.segment29
1199: ,'100')),125) ptp
1200: FROM per_assignments_f asg
1201: ,hr_soft_coding_keyflex target
1202: WHERE asg.assignment_id = c_asg_id

Line 1245: SELECT least (fnd_number.canonical_to_number (nvl (target.segment29

1241: AND pet.element_name = c_element_name;
1242: --=========================================================================
1243: CURSOR csr_cur_ptp(c_effective_date IN DATE
1244: ,c_asg_id IN NUMBER) IS
1245: SELECT least (fnd_number.canonical_to_number (nvl (target.segment29
1246: ,'100'))
1247: ,125) ptp
1248: FROM per_assignments_f asg
1249: ,hr_soft_coding_keyflex target

Line 1274: ,fnd_number.canonical_to_number (peev.screen_entry_value) ptp

1270: ,c_ele_type_id IN NUMBER
1271: ,c_input_val_id IN NUMBER ) IS
1272: SELECT pay_paywsmee_pkg.get_original_date_earned (peef.element_entry_id) start_date
1273: ,pay_paywsmee_pkg.get_original_date_earned (peef.element_entry_id) end_date
1274: ,fnd_number.canonical_to_number (peev.screen_entry_value) ptp
1275: FROM pay_element_entries_f peef
1276: ,pay_element_links_f pelf
1277: ,pay_element_entry_values_f peev
1278: WHERE c_effective_date BETWEEN peef.effective_start_date

Line 1514: SELECT fnd_number.canonical_to_number (nvl (screen_entry_value

1510: -- (for all numeric input values)
1511: -- ============================================================================
1512: CURSOR csr_get_retro_num_value(c_element_entry_id in number
1513: ,c_input_value_id in number) IS
1514: SELECT fnd_number.canonical_to_number (nvl (screen_entry_value
1515: ,'0')) amt
1516: ,pay_paywsmee_pkg.get_original_date_earned(c_element_entry_id) date_earned
1517: FROM pay_element_entry_values_f
1518: WHERE element_entry_id = c_element_entry_id

Line 1590: (c_element_type_id => fnd_number.canonical_to_number(

1586: --
1587: -- Current Year Retro
1588: --
1589: FOR temp_rec IN csr_get_retro_entry
1590: (c_element_type_id => fnd_number.canonical_to_number(
1591: l_contr_basis(i).cy_retro_element_id)
1592: ,c_assignment_action_id => act_rec.assignment_action_id)
1593: LOOP
1594: hr_utility.trace('Found current year retro entries - Contr Basis');

Line 1599: fnd_number.canonical_to_number(l_contr_basis(i).cy_retro_element_id));

1595: --
1596: -- Fetch the input value id for ABP Employee Pension Basis input value
1597: --
1598: OPEN csr_get_iv_id(c_element_type_id =>
1599: fnd_number.canonical_to_number(l_contr_basis(i).cy_retro_element_id));
1600: FETCH csr_get_iv_id INTO l_basis_iv_id;
1601: CLOSE csr_get_iv_id;
1602:
1603: --

Line 1890: SELECT fnd_number.canonical_to_number(pai.action_information8) contr_amt

1886: CURSOR csr_prev_contr_amt (c_assignment_id IN NUMBER
1887: ,c_effective_date IN DATE
1888: ,c_pension_type IN VARCHAR2
1889: ,c_pension_type_variant IN VARCHAR2) IS
1890: SELECT fnd_number.canonical_to_number(pai.action_information8) contr_amt
1891: FROM pay_action_information pai
1892: WHERE pai.action_information_category = 'NL_ABP_PENSION_INFO'
1893: AND pai.action_context_type = 'AAP'
1894: AND pai.assignment_id = c_assignment_id

Line 2795: ,least (fnd_number.canonical_to_number (aei_information5)

2791: -- Participation Details
2792: /*CURSOR csr_part_details(c_assignment_id IN NUMBER
2793: ,c_effective_date IN DATE) IS
2794: SELECT aei_information4 kop
2795: ,least (fnd_number.canonical_to_number (aei_information5)
2796: ,1) * 100 vop
2797: FROM per_assignment_extra_info
2798: WHERE information_type = 'NL_ABP_PAR_INFO'
2799: AND aei_information_category = 'NL_ABP_PAR_INFO'

Line 2809: , least (fnd_number.canonical_to_number (aei_information5), 1) * 100 vop

2805: CURSOR csr_part_details(c_assignment_id IN NUMBER
2806: ,c_eff_start_date IN DATE
2807: ,c_eff_end_date IN DATE) IS
2808: SELECT aei_information4 kop
2809: , least (fnd_number.canonical_to_number (aei_information5), 1) * 100 vop
2810: , fnd_date.canonical_to_date (aei_information1) kop_start_date
2811: , nvl (fnd_date.canonical_to_date (aei_information2), c_eff_end_date) kop_end_date
2812: FROM per_assignment_extra_info
2813: WHERE information_type = 'NL_ABP_PAR_INFO'

Line 2826: , least (fnd_number.canonical_to_number (paei.aei_information5), 1) * 100 vop

2822: ,c_assignment_id IN NUMBER) IS
2823: SELECT *
2824: FROM (
2825: SELECT pai.action_information1 start_date
2826: , least (fnd_number.canonical_to_number (paei.aei_information5), 1) * 100 vop
2827: FROM pay_action_information pai
2828: , per_assignment_extra_info paei
2829: WHERE paei.information_type = 'NL_ABP_PAR_INFO'
2830: AND paei.aei_information_category = 'NL_ABP_PAR_INFO'

Line 3585: , p_action_information5 => fnd_number.number_to_canonical(round(lv_ptp,2)/100)

3581: , p_action_information1 => fnd_date.date_to_canonical(l_wne_start_date)
3582: , p_action_information2 => fnd_date.date_to_canonical(l_wne_end_date)
3583: , p_action_information3 => 'WNE'
3584: , p_action_information4 => l_income_code
3585: , p_action_information5 => fnd_number.number_to_canonical(round(lv_ptp,2)/100)
3586: , p_action_information6 => l_empty_pay_period
3587: );
3588: hr_utility.trace('l_kop_report: '||l_kop_report);
3589: IF l_kop_report = 'Y' THEN

Line 3644: , p_action_information5 => fnd_number.number_to_canonical(round(lv_ptp,2)/100)

3640: , p_action_information1 => fnd_date.date_to_canonical(greatest(lv_start_date,l_asg_start_date,l_kop_start_date))
3641: , p_action_information2 => fnd_date.date_to_canonical(lv_spl_date)
3642: , p_action_information3 => nvl(l_part_details.kop,'WNE')
3643: , p_action_information4 => l_income_code
3644: , p_action_information5 => fnd_number.number_to_canonical(round(lv_ptp,2)/100)
3645: , p_action_information6 => l_empty_pay_period
3646: );
3647:
3648: IF lv_spl_date IS NULL THEN

Line 3703: , p_action_information5 => fnd_number.number_to_canonical(round(lv_ptp,2)/100)

3699: , p_action_information1 => fnd_date.date_to_canonical(greatest(lv_start_date,l_asg_start_date,l_temp_date))
3700: , p_action_information2 => fnd_date.date_to_canonical(l_wne_end_date)
3701: , p_action_information3 => 'WNE'
3702: , p_action_information4 => l_income_code
3703: , p_action_information5 => fnd_number.number_to_canonical(round(lv_ptp,2)/100)
3704: , p_action_information6 => l_empty_pay_period
3705: );
3706: END IF;
3707: EXIT;

Line 3752: , p_action_information6 => fnd_number.number_to_canonical(round(l_pension_salary,2))

3748: , p_action_information2 => l_all_contr_amt_values(i).pension_type_variant
3749: , p_action_information3 => fnd_date.date_to_canonical(l_pension_st_date)
3750: , p_action_information4 => fnd_date.date_to_canonical(l_all_contr_amt_values(i).date_earned)
3751: , p_action_information5 => 'R'
3752: , p_action_information6 => fnd_number.number_to_canonical(round(l_pension_salary,2))
3753: , p_action_information7 => fnd_number.number_to_canonical(round(l_all_contr_amt_values(i).contr_base,2))
3754: , p_action_information8 => fnd_number.number_to_canonical(round(l_all_contr_amt_values(i).contr_amt,2))
3755: , p_action_information9 => l_all_part_details.vop
3756: , p_action_information10 => l_all_part_details.start_date

Line 3753: , p_action_information7 => fnd_number.number_to_canonical(round(l_all_contr_amt_values(i).contr_base,2))

3749: , p_action_information3 => fnd_date.date_to_canonical(l_pension_st_date)
3750: , p_action_information4 => fnd_date.date_to_canonical(l_all_contr_amt_values(i).date_earned)
3751: , p_action_information5 => 'R'
3752: , p_action_information6 => fnd_number.number_to_canonical(round(l_pension_salary,2))
3753: , p_action_information7 => fnd_number.number_to_canonical(round(l_all_contr_amt_values(i).contr_base,2))
3754: , p_action_information8 => fnd_number.number_to_canonical(round(l_all_contr_amt_values(i).contr_amt,2))
3755: , p_action_information9 => l_all_part_details.vop
3756: , p_action_information10 => l_all_part_details.start_date
3757: , p_action_information11 => fnd_date.date_to_canonical(l_asg_end_date)

Line 3754: , p_action_information8 => fnd_number.number_to_canonical(round(l_all_contr_amt_values(i).contr_amt,2))

3750: , p_action_information4 => fnd_date.date_to_canonical(l_all_contr_amt_values(i).date_earned)
3751: , p_action_information5 => 'R'
3752: , p_action_information6 => fnd_number.number_to_canonical(round(l_pension_salary,2))
3753: , p_action_information7 => fnd_number.number_to_canonical(round(l_all_contr_amt_values(i).contr_base,2))
3754: , p_action_information8 => fnd_number.number_to_canonical(round(l_all_contr_amt_values(i).contr_amt,2))
3755: , p_action_information9 => l_all_part_details.vop
3756: , p_action_information10 => l_all_part_details.start_date
3757: , p_action_information11 => fnd_date.date_to_canonical(l_asg_end_date)
3758: );