APPS.PAY_SG_IRAS_MAGTAPE dependencies on FND_DATE

Line 195: to_char(fnd_date.canonical_to_date(ac3.context),'MON') month,

191: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', apa.legislative_parameters) tax_unit_id,
192: 'DATE_EARNED=C',
193: ac3.context date_earned,
194: 'MONTH=P',
195: to_char(fnd_date.canonical_to_date(ac3.context),'MON') month,
196: 'PERSON_ID=P',
197: to_char(paa.person_id) person_id,
198: 'DATE_ORDER=P',
199: fnd_date.canonical_to_date(ac3.context) date_order

Line 199: fnd_date.canonical_to_date(ac3.context) date_order

195: to_char(fnd_date.canonical_to_date(ac3.context),'MON') month,
196: 'PERSON_ID=P',
197: to_char(paa.person_id) person_id,
198: 'DATE_ORDER=P',
199: fnd_date.canonical_to_date(ac3.context) date_order
200: from per_all_assignments_f paa,
201: pay_payroll_actions apa,
202: pay_assignment_actions aac,
203: pay_payroll_actions mpa,

Line 223: order by paa.person_id, fnd_date.canonical_to_date(ac3.context);

219: and ffe.route_id = ffr.route_id
220: and ffr.route_name = 'SG IRAS Month Balances Archive'
221: and (paa.effective_start_date <= to_date('31/' || '12/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy')
222: and paa.effective_end_date >= to_date('01/' || '01/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy'))
223: order by paa.person_id, fnd_date.canonical_to_date(ac3.context);
224:
225: ---------------------------------------------------------------------
226: -- Passes parameters to SG_IR8S_WAGE_DETAILS
227: -- Modified for bug 3027801