APPS.PAY_ZA_SOE dependencies on FND_NUMBER

Line 75: ,to_char(sum(fnd_number.canonical_to_number(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16

71: --
72:
73: l_sql := 'Select nvl(ettl.reporting_name,et.element_type_id) COL01
74: ,nvl(ettl.reporting_name,ettl.element_name) COL02
75: ,to_char(sum(fnd_number.canonical_to_number(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
76: ,decode(count(*),1,''1'',''2'') COL17 -- destination indicator
77: ,decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
78: From pay_assignment_actions aa
79: ,pay_run_results rr

Line 110: having nvl(sum(fnd_number.canonical_to_number(rrv.result_value)),0) != 0

106: and es.element_set_name = '''|| p_element_set_name ||'''
107: group by nvl(ettl.reporting_name,ettl.element_name)
108: ,ettl.reporting_name
109: ,nvl(ettl.reporting_name,et.element_type_id)
110: having nvl(sum(fnd_number.canonical_to_number(rrv.result_value)),0) != 0
111: order by nvl(ettl.reporting_name,ettl.element_name)';
112: --
113: if g_debug then
114: hr_utility.set_location('Leaving pay_soe_glb.getElements', 20);

Line 167: ,to_char(fnd_number.canonical_to_number(nvl(ppb1.salary,''0'')),fnd_currency.get_format_mask(:g_currency_code,40)) as COL13

163: ,hl.meaning as COL09 -- Nationality
164: ,asg.assignment_number as COL10
165: ,fnd_date.date_to_displaydate(pps.date_start) as COL11
166: ,fnd_date.date_to_displaydate(pps.actual_termination_date) as COL12
167: ,to_char(fnd_number.canonical_to_number(nvl(ppb1.salary,''0'')),fnd_currency.get_format_mask(:g_currency_code,40)) as COL13
168: ,peo.per_information1 as COL14 -- Tax Reference Number
169: ,pay_za_soe.get_tax_status(asg.assignment_id, :effective_date) as COL15
170: ,ptp.period_num as COL16
171: From per_all_people_f peo

Line 576: balance_val := to_char(fnd_number.canonical_to_number(balance_val),fnd_currency.get_format_mask('ZAR',40));

572: -- Use the get_value package to get value of balance
573: balance_val := pay_balance_pkg.get_value(dim_id, l_run_assignment_action_id, false);
574:
575: if nvl(balance_val, 0) <> 0 then
576: balance_val := to_char(fnd_number.canonical_to_number(balance_val),fnd_currency.get_format_mask('ZAR',40));
577: pay_soe_util.setValue('01', balance_name, true, false);
578: pay_soe_util.setValue('02', display_name, false, false);
579: pay_soe_util.setValue('16', balance_val, false, true);
580: end if;

Line 848: balance_val := to_char(fnd_number.canonical_to_number(balance_val),fnd_currency.get_format_mask('ZAR',40));

844: -- Use the get_value package to get value of balance
845: balance_val := pay_balance_pkg.get_value(dim_id, l_run_assignment_action_id, false);
846:
847: if nvl(balance_val, 0) <> 0 then
848: balance_val := to_char(fnd_number.canonical_to_number(balance_val),fnd_currency.get_format_mask('ZAR',40));
849: pay_soe_util.setValue('01', balance_name, true, false);
850: pay_soe_util.setValue('02', balance_name, false, false);
851: pay_soe_util.setValue('16', balance_val, false, true);
852: end if;