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_AU_TFN_MAGTAPE dependencies on PAY_CORE_UTILS

Line 221: AND fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORT_END_DATE',ppa.legislative_parameters))

217: FROM pay_payroll_actions ppa,
218: pay_assignment_actions pac
219: WHERE pac.assignment_id = paa.assignment_id
220: AND ppa.payroll_Action_id = pac.payroll_action_id
221: AND fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORT_END_DATE',ppa.legislative_parameters))
222: BETWEEN c_report_end_date - 13 AND c_report_end_date
223: AND pac.action_status = 'C'
224: AND ppa.action_TYPE = 'X'
225: AND ppa.report_TYPE = 'AU_TFN_MAGTAPE');

Line 237: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),

233: /* Bug 3229452 - Used fnd_date.canonical_to_date instead of to_date for selecting
234: report end date from ppa.legislative paramenters */
235: CURSOR c_get_parameters( c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE) IS
236: SELECT
237: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),
238: pay_core_utils.get_parameter('LEGAL_EMPLOYER',ppa.legislative_parameters),
239: fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORT_END_DATE',ppa.legislative_parameters))-1
240: FROM pay_payroll_actions ppa
241: WHERE ppa.payroll_action_id = c_payroll_action_id;

Line 238: pay_core_utils.get_parameter('LEGAL_EMPLOYER',ppa.legislative_parameters),

234: report end date from ppa.legislative paramenters */
235: CURSOR c_get_parameters( c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE) IS
236: SELECT
237: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),
238: pay_core_utils.get_parameter('LEGAL_EMPLOYER',ppa.legislative_parameters),
239: fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORT_END_DATE',ppa.legislative_parameters))-1
240: FROM pay_payroll_actions ppa
241: WHERE ppa.payroll_action_id = c_payroll_action_id;
242:

Line 239: fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORT_END_DATE',ppa.legislative_parameters))-1

235: CURSOR c_get_parameters( c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE) IS
236: SELECT
237: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),
238: pay_core_utils.get_parameter('LEGAL_EMPLOYER',ppa.legislative_parameters),
239: fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORT_END_DATE',ppa.legislative_parameters))-1
240: FROM pay_payroll_actions ppa
241: WHERE ppa.payroll_action_id = c_payroll_action_id;
242:
243: l_business_group_id per_business_groups.business_group_id%TYPE;

Line 325: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),

321: /* Bug 3229452 - Used fnd_date.canonical_to_date instead of to_date for selecting
322: report end date from ppa.legislative paramenters */
323: CURSOR c_get_parameters( c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE) IS
324: SELECT
325: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),
326: pay_core_utils.get_parameter('LEGAL_EMPLOYER',ppa.legislative_parameters),
327: fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORT_END_DATE',ppa.legislative_parameters))-1
328: FROM pay_payroll_actions ppa
329: WHERE ppa.payroll_action_id = c_payroll_action_id;

Line 326: pay_core_utils.get_parameter('LEGAL_EMPLOYER',ppa.legislative_parameters),

322: report end date from ppa.legislative paramenters */
323: CURSOR c_get_parameters( c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE) IS
324: SELECT
325: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),
326: pay_core_utils.get_parameter('LEGAL_EMPLOYER',ppa.legislative_parameters),
327: fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORT_END_DATE',ppa.legislative_parameters))-1
328: FROM pay_payroll_actions ppa
329: WHERE ppa.payroll_action_id = c_payroll_action_id;
330:

Line 327: fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORT_END_DATE',ppa.legislative_parameters))-1

323: CURSOR c_get_parameters( c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE) IS
324: SELECT
325: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),
326: pay_core_utils.get_parameter('LEGAL_EMPLOYER',ppa.legislative_parameters),
327: fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORT_END_DATE',ppa.legislative_parameters))-1
328: FROM pay_payroll_actions ppa
329: WHERE ppa.payroll_action_id = c_payroll_action_id;
330:
331: l_business_group_id per_business_groups.business_group_id%TYPE;