APPS.PAY_ZA_SOE dependencies on FND_DATE

Line 29: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(p_date_earned));

25: end if;
26: --
27:
28: pay_balance_pkg.set_context('ASSIGNMENT_ID', to_char(p_assignment_id));
29: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(p_date_earned));
30:
31: l_tax_status := pay_balance_pkg.run_db_item('ZA_TAX_TAX_STATUS_ENTRY_VALUE', null, 'ZA');
32:
33: begin

Line 165: ,fnd_date.date_to_displaydate(pps.date_start) as COL11

161: ,peo.national_identifier as COL07
162: ,employee_number as COL08
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

Line 166: ,fnd_date.date_to_displaydate(pps.actual_termination_date) as COL12

162: ,employee_number as COL08
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

Line 273: ,fnd_date.date_to_displaydate(ppa.effective_date) as COL02 -- Pay Date

269: );
270: --
271: l_sql :=
272: 'Select ptp.period_name as COL01 -- Period Name
273: ,fnd_date.date_to_displaydate(ppa.effective_date) as COL02 -- Pay Date
274: ,ptp.period_type as COL03 -- Period Type
275: ,fnd_date.date_to_displaydate(ptp.start_date) as COL04 -- Period Start Date
276: ,fnd_date.date_to_displaydate(ptp.end_date) as COL05 -- Period End Date
277: From per_time_periods ptp

Line 275: ,fnd_date.date_to_displaydate(ptp.start_date) as COL04 -- Period Start Date

271: l_sql :=
272: 'Select ptp.period_name as COL01 -- Period Name
273: ,fnd_date.date_to_displaydate(ppa.effective_date) as COL02 -- Pay Date
274: ,ptp.period_type as COL03 -- Period Type
275: ,fnd_date.date_to_displaydate(ptp.start_date) as COL04 -- Period Start Date
276: ,fnd_date.date_to_displaydate(ptp.end_date) as COL05 -- Period End Date
277: From per_time_periods ptp
278: ,pay_payroll_actions ppa
279: ,pay_assignment_actions paa

Line 276: ,fnd_date.date_to_displaydate(ptp.end_date) as COL05 -- Period End Date

272: 'Select ptp.period_name as COL01 -- Period Name
273: ,fnd_date.date_to_displaydate(ppa.effective_date) as COL02 -- Pay Date
274: ,ptp.period_type as COL03 -- Period Type
275: ,fnd_date.date_to_displaydate(ptp.start_date) as COL04 -- Period Start Date
276: ,fnd_date.date_to_displaydate(ptp.end_date) as COL05 -- Period End Date
277: From per_time_periods ptp
278: ,pay_payroll_actions ppa
279: ,pay_assignment_actions paa
280: ,per_time_period_types ptt

Line 948: ,fnd_date.date_to_displaydate( '

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
952: ,pay_personal_payment_methods_f pppmf