APPS.PAY_ZA_SOE dependencies on FND_CURRENCY

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 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 890: balance_val := to_char(fnd_number.canonical_to_number(balance_val),fnd_currency.get_format_mask('ZAR',40));

886: -- Use the get_value package to get value of balance
887: balance_val := pay_balance_pkg.get_value(dim_id, l_run_assignment_action_id, false);
888:
889: if nvl(balance_val, 0) <> 0 then
890: balance_val := to_char(fnd_number.canonical_to_number(balance_val),fnd_currency.get_format_mask('ZAR',40));
891: pay_soe_util.setValue('01', balance_name, true, false);
892: pay_soe_util.setValue('02', balance_name, false, false);
893: pay_soe_util.setValue('16', balance_val, false, true);
894: end if;

Line 947: ,to_char(ppp.value, fnd_currency.get_format_mask(:g_currency_code,40)) as COL16 -- Payment Amount -- Bug 4392560

943: ,ppt.payment_type_name as COL02 -- Payment Type
944: ,cdv.bank_name as COL03 -- Bank
945: ,pea.segment1 as COL04 -- Branch Code
946: ,pea.segment3 as COL05 -- Account No
947: ,to_char(ppp.value, fnd_currency.get_format_mask(:g_currency_code,40)) as COL16 -- Payment Amount -- Bug 4392560
948: ,fnd_date.date_to_displaydate( '
949: || 'to_date(''' || l_date_earned ||''','|| '''YYYY/MM/DD''' ||')'
950: ||') as COL06 -- Payment_date
951: From pay_pre_payments ppp