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 183: AND ((trunc(fnd_date.canonical_to_date(pee.entry_information1)) BETWEEN c_report_end_date -13 AND c_report_end_date

179: AND pel.element_type_id = pet.element_type_id
180: AND pee.element_link_id = pel.element_link_id
181: AND pee.assignment_id = paa.assignment_id
182: AND pee.entry_information_category = 'AU_TAX DEDUCTIONS'
183: AND ((trunc(fnd_date.canonical_to_date(pee.entry_information1)) BETWEEN c_report_end_date -13 AND c_report_end_date
184: and pps.actual_termination_date is null)
185: 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'))
186: AND piv.name = 'Tax File Number'
187: AND piv.element_type_id = pet.element_type_id

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

227: FROM pay_payroll_actions ppa,
228: pay_assignment_actions pac
229: WHERE pac.assignment_id = paa.assignment_id
230: AND ppa.payroll_Action_id = pac.payroll_action_id
231: AND fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORT_END_DATE',ppa.legislative_parameters))
232: BETWEEN c_report_end_date - 13 AND c_report_end_date
233: AND pac.action_status = 'C'
234: AND ppa.action_TYPE = 'X'
235: AND ppa.report_TYPE = 'AU_TFN_MAGTAPE');

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

239: ----------------------------------------------------------------------------------
240: -- Cursor to fetch the passed parameters to the magtape process
241: ----------------------------------------------------------------------------------
242: /* Bug 2974527 - Changed the cursor to consider report end date -1 */
243: /* Bug 3229452 - Used fnd_date.canonical_to_date instead of to_date for selecting
244: report end date from ppa.legislative paramenters */
245: CURSOR c_get_parameters( c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE) IS
246: SELECT
247: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),

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

245: CURSOR c_get_parameters( c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE) IS
246: SELECT
247: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),
248: pay_core_utils.get_parameter('LEGAL_EMPLOYER',ppa.legislative_parameters),
249: fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORT_END_DATE',ppa.legislative_parameters))-1
250: FROM pay_payroll_actions ppa
251: WHERE ppa.payroll_action_id = c_payroll_action_id;
252:
253: l_business_group_id per_business_groups.business_group_id%TYPE;

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

327: ----------------------------------------------------------------------------------
328: -- CURSOR to FETCH the passed parameters to the magtape process
329: ----------------------------------------------------------------------------------
330: /* Bug 2974527 - Changed the cursor to consider report end date -1 */
331: /* Bug 3229452 - Used fnd_date.canonical_to_date instead of to_date for selecting
332: report end date from ppa.legislative paramenters */
333: CURSOR c_get_parameters( c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE) IS
334: SELECT
335: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),

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

333: CURSOR c_get_parameters( c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE) IS
334: SELECT
335: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),
336: pay_core_utils.get_parameter('LEGAL_EMPLOYER',ppa.legislative_parameters),
337: fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORT_END_DATE',ppa.legislative_parameters))-1
338: FROM pay_payroll_actions ppa
339: WHERE ppa.payroll_action_id = c_payroll_action_id;
340:
341: l_business_group_id per_business_groups.business_group_id%TYPE;