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_SG_IRAS_MAGTAPE dependencies on FND_DATE

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

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

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

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

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

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