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 FND_DATE

Line 124: /* Bug 2974527 - Added trunc for fnd_date.canonical_to_date function */

120: /* Bug 2728358 - Added check for employee terminated on report end date */
121:
122: /*Bug2920725 Corrected base tables to support security model*/
123:
124: /* Bug 2974527 - Added trunc for fnd_date.canonical_to_date function */
125: /* Bug 2974527 - Backed out the changed for Bug 2974527*/
126: /* Bug 3229452 - Used fnd_date.canonical_to_date instead of to_date for selecting
127: report end date from ppa.legislative paramenters */
128: /* Bug 4215439 - Added ORDERED hint TO the assignment cursor*/

Line 126: /* Bug 3229452 - Used fnd_date.canonical_to_date instead of to_date for selecting

122: /*Bug2920725 Corrected base tables to support security model*/
123:
124: /* Bug 2974527 - Added trunc for fnd_date.canonical_to_date function */
125: /* Bug 2974527 - Backed out the changed for Bug 2974527*/
126: /* Bug 3229452 - Used fnd_date.canonical_to_date instead of to_date for selecting
127: report end date from ppa.legislative paramenters */
128: /* Bug 4215439 - Added ORDERED hint TO the assignment cursor*/
129: /*Bug 5348307 - Commented condition
130: c_report_end_date BETWEEN paa.effective_start_date AND paa.effective_end_date

Line 186: AND ((trunc(fnd_date.canonical_to_date(pee.entry_information1)) BETWEEN c_report_end_date -13 AND c_report_end_date) /* 8352719 */

182: AND pel.element_type_id = pet.element_type_id
183: AND pee.element_link_id = pel.element_link_id
184: AND pee.assignment_id = paa.assignment_id
185: AND pee.entry_information_category = 'AU_TAX DEDUCTIONS'
186: AND ((trunc(fnd_date.canonical_to_date(pee.entry_information1)) BETWEEN c_report_end_date -13 AND c_report_end_date) /* 8352719 */
187: OR (nvl(pps.actual_termination_date,to_date('31/12/4712','DD/MM/YYYY')) BETWEEN c_report_end_date - 13 AND c_report_end_date and peev.screen_entry_value = '111 111 111'))
188: AND piv.name = 'Tax File Number'
189: AND piv.element_type_id = pet.element_type_id
190: AND peev.input_value_id = piv.input_value_id

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 233: /* Bug 3229452 - Used fnd_date.canonical_to_date instead of to_date for selecting

229: ----------------------------------------------------------------------------------
230: -- Cursor to fetch the passed parameters to the magtape process
231: ----------------------------------------------------------------------------------
232: /* Bug 2974527 - Changed the cursor to consider report end date -1 */
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),

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 321: /* Bug 3229452 - Used fnd_date.canonical_to_date instead of to_date for selecting

317: ----------------------------------------------------------------------------------
318: -- CURSOR to FETCH the passed parameters to the magtape process
319: ----------------------------------------------------------------------------------
320: /* Bug 2974527 - Changed the cursor to consider report end date -1 */
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),

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;