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

Line 311: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||

307: FROM pay_assignment_actions paa,
308: pay_payroll_actions ppa,
309: per_assignments_f paf
310: WHERE ppa.business_group_id = ' || ln_business_group_id || '
311: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
312: fnd_date.date_to_canonical(ld_start_date) || ''')
313: AND fnd_date.canonical_to_date(''' ||
314: fnd_date.date_to_canonical(ld_end_date) || ''')
315: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')

Line 312: fnd_date.date_to_canonical(ld_start_date) || ''')

308: pay_payroll_actions ppa,
309: per_assignments_f paf
310: WHERE ppa.business_group_id = ' || ln_business_group_id || '
311: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
312: fnd_date.date_to_canonical(ld_start_date) || ''')
313: AND fnd_date.canonical_to_date(''' ||
314: fnd_date.date_to_canonical(ld_end_date) || ''')
315: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')
316: AND ppa.payroll_action_id = paa.payroll_action_id

Line 313: AND fnd_date.canonical_to_date(''' ||

309: per_assignments_f paf
310: WHERE ppa.business_group_id = ' || ln_business_group_id || '
311: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
312: fnd_date.date_to_canonical(ld_start_date) || ''')
313: AND fnd_date.canonical_to_date(''' ||
314: fnd_date.date_to_canonical(ld_end_date) || ''')
315: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')
316: AND ppa.payroll_action_id = paa.payroll_action_id
317: AND paa.source_action_id IS NULL

Line 314: fnd_date.date_to_canonical(ld_end_date) || ''')

310: WHERE ppa.business_group_id = ' || ln_business_group_id || '
311: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
312: fnd_date.date_to_canonical(ld_start_date) || ''')
313: AND fnd_date.canonical_to_date(''' ||
314: fnd_date.date_to_canonical(ld_end_date) || ''')
315: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')
316: AND ppa.payroll_action_id = paa.payroll_action_id
317: AND paa.source_action_id IS NULL
318: AND paf.assignment_id = paa.assignment_id

Line 331: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||

327: FROM pay_assignment_actions paa,
328: pay_payroll_actions ppa,
329: per_assignments_f paf
330: WHERE ppa.business_group_id = ' || ln_business_group_id || '
331: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
332: fnd_date.date_to_canonical(ld_start_date) || ''')
333: AND fnd_date.canonical_to_date(''' ||
334: fnd_date.date_to_canonical(ld_end_date) || ''')
335: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')

Line 332: fnd_date.date_to_canonical(ld_start_date) || ''')

328: pay_payroll_actions ppa,
329: per_assignments_f paf
330: WHERE ppa.business_group_id = ' || ln_business_group_id || '
331: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
332: fnd_date.date_to_canonical(ld_start_date) || ''')
333: AND fnd_date.canonical_to_date(''' ||
334: fnd_date.date_to_canonical(ld_end_date) || ''')
335: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')
336: AND ppa.payroll_action_id = paa.payroll_action_id

Line 333: AND fnd_date.canonical_to_date(''' ||

329: per_assignments_f paf
330: WHERE ppa.business_group_id = ' || ln_business_group_id || '
331: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
332: fnd_date.date_to_canonical(ld_start_date) || ''')
333: AND fnd_date.canonical_to_date(''' ||
334: fnd_date.date_to_canonical(ld_end_date) || ''')
335: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')
336: AND ppa.payroll_action_id = paa.payroll_action_id
337: AND paa.source_action_id IS NULL

Line 334: fnd_date.date_to_canonical(ld_end_date) || ''')

330: WHERE ppa.business_group_id = ' || ln_business_group_id || '
331: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
332: fnd_date.date_to_canonical(ld_start_date) || ''')
333: AND fnd_date.canonical_to_date(''' ||
334: fnd_date.date_to_canonical(ld_end_date) || ''')
335: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')
336: AND ppa.payroll_action_id = paa.payroll_action_id
337: AND paa.source_action_id IS NULL
338: AND paf.assignment_id = paa.assignment_id