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 317: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||

313: FROM pay_assignment_actions paa,
314: pay_payroll_actions ppa,
315: per_assignments_f paf
316: WHERE ppa.business_group_id = ' || ln_business_group_id || '
317: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
318: fnd_date.date_to_canonical(ld_start_date) || ''')
319: AND fnd_date.canonical_to_date(''' ||
320: fnd_date.date_to_canonical(ld_end_date) || ''')
321: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')

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

314: pay_payroll_actions ppa,
315: per_assignments_f paf
316: WHERE ppa.business_group_id = ' || ln_business_group_id || '
317: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
318: fnd_date.date_to_canonical(ld_start_date) || ''')
319: AND fnd_date.canonical_to_date(''' ||
320: fnd_date.date_to_canonical(ld_end_date) || ''')
321: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')
322: AND ppa.payroll_action_id = paa.payroll_action_id

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

315: per_assignments_f paf
316: WHERE ppa.business_group_id = ' || ln_business_group_id || '
317: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
318: fnd_date.date_to_canonical(ld_start_date) || ''')
319: AND fnd_date.canonical_to_date(''' ||
320: fnd_date.date_to_canonical(ld_end_date) || ''')
321: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')
322: AND ppa.payroll_action_id = paa.payroll_action_id
323: AND paa.source_action_id IS NULL

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

316: WHERE ppa.business_group_id = ' || ln_business_group_id || '
317: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
318: fnd_date.date_to_canonical(ld_start_date) || ''')
319: AND fnd_date.canonical_to_date(''' ||
320: fnd_date.date_to_canonical(ld_end_date) || ''')
321: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')
322: AND ppa.payroll_action_id = paa.payroll_action_id
323: AND paa.source_action_id IS NULL
324: AND paf.assignment_id = paa.assignment_id

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

333: FROM pay_assignment_actions paa,
334: pay_payroll_actions ppa,
335: per_assignments_f paf
336: WHERE ppa.business_group_id = ' || ln_business_group_id || '
337: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
338: fnd_date.date_to_canonical(ld_start_date) || ''')
339: AND fnd_date.canonical_to_date(''' ||
340: fnd_date.date_to_canonical(ld_end_date) || ''')
341: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')

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

334: pay_payroll_actions ppa,
335: per_assignments_f paf
336: WHERE ppa.business_group_id = ' || ln_business_group_id || '
337: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
338: fnd_date.date_to_canonical(ld_start_date) || ''')
339: AND fnd_date.canonical_to_date(''' ||
340: fnd_date.date_to_canonical(ld_end_date) || ''')
341: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')
342: AND ppa.payroll_action_id = paa.payroll_action_id

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

335: per_assignments_f paf
336: WHERE ppa.business_group_id = ' || ln_business_group_id || '
337: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
338: fnd_date.date_to_canonical(ld_start_date) || ''')
339: AND fnd_date.canonical_to_date(''' ||
340: fnd_date.date_to_canonical(ld_end_date) || ''')
341: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')
342: AND ppa.payroll_action_id = paa.payroll_action_id
343: AND paa.source_action_id IS NULL

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

336: WHERE ppa.business_group_id = ' || ln_business_group_id || '
337: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
338: fnd_date.date_to_canonical(ld_start_date) || ''')
339: AND fnd_date.canonical_to_date(''' ||
340: fnd_date.date_to_canonical(ld_end_date) || ''')
341: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')
342: AND ppa.payroll_action_id = paa.payroll_action_id
343: AND paa.source_action_id IS NULL
344: AND paf.assignment_id = paa.assignment_id