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

Line 21: ,replace(substr(FND_DATE.DATE_TO_CANONICAL(pa.effective_date),1,10),'/','-') jsqldate --YYYY-MM-DD

17: --
18: cursor getParameters(c_assignment_action_id in number) is
19: select pa.payroll_id
20: --, to_number(to_char(pa.effective_date,'J')) effective_date
21: ,replace(substr(FND_DATE.DATE_TO_CANONICAL(pa.effective_date),1,10),'/','-') jsqldate --YYYY-MM-DD
22: ,'' || pa.effective_date || '' effective_date
23: , aa.assignment_id
24: , pa.business_group_id
25: , aa.tax_unit_id

Line 323: ,fnd_date.date_to_displaydate(tp1.end_date) COL04

319: if l_action_type is not null then
320: if l_action_type in ( 'P','U' ) then
321: l_sql :=
322: 'select tp1.period_name || decode(tp2.period_name, tp1.period_name, null, '' - '' || tp2.period_name) COL01
323: ,fnd_date.date_to_displaydate(tp1.end_date) COL04
324: ,fnd_date.date_to_displaydate(pa2.effective_date) COL03
325: ,fnd_date.date_to_displaydate(aa1.start_date) COL05
326: ,fnd_date.date_to_displaydate(aa2.end_date) COL06
327: ,fnd_date.date_to_displaydate(tp1.start_date) COL02

Line 324: ,fnd_date.date_to_displaydate(pa2.effective_date) COL03

320: if l_action_type in ( 'P','U' ) then
321: l_sql :=
322: 'select tp1.period_name || decode(tp2.period_name, tp1.period_name, null, '' - '' || tp2.period_name) COL01
323: ,fnd_date.date_to_displaydate(tp1.end_date) COL04
324: ,fnd_date.date_to_displaydate(pa2.effective_date) COL03
325: ,fnd_date.date_to_displaydate(aa1.start_date) COL05
326: ,fnd_date.date_to_displaydate(aa2.end_date) COL06
327: ,fnd_date.date_to_displaydate(tp1.start_date) COL02
328: ,tp1.period_type COL07

Line 325: ,fnd_date.date_to_displaydate(aa1.start_date) COL05

321: l_sql :=
322: 'select tp1.period_name || decode(tp2.period_name, tp1.period_name, null, '' - '' || tp2.period_name) COL01
323: ,fnd_date.date_to_displaydate(tp1.end_date) COL04
324: ,fnd_date.date_to_displaydate(pa2.effective_date) COL03
325: ,fnd_date.date_to_displaydate(aa1.start_date) COL05
326: ,fnd_date.date_to_displaydate(aa2.end_date) COL06
327: ,fnd_date.date_to_displaydate(tp1.start_date) COL02
328: ,tp1.period_type COL07
329: from pay_all_payrolls_f pp1

Line 326: ,fnd_date.date_to_displaydate(aa2.end_date) COL06

322: 'select tp1.period_name || decode(tp2.period_name, tp1.period_name, null, '' - '' || tp2.period_name) COL01
323: ,fnd_date.date_to_displaydate(tp1.end_date) COL04
324: ,fnd_date.date_to_displaydate(pa2.effective_date) COL03
325: ,fnd_date.date_to_displaydate(aa1.start_date) COL05
326: ,fnd_date.date_to_displaydate(aa2.end_date) COL06
327: ,fnd_date.date_to_displaydate(tp1.start_date) COL02
328: ,tp1.period_type COL07
329: from pay_all_payrolls_f pp1
330: ,pay_all_payrolls_f pp2

Line 327: ,fnd_date.date_to_displaydate(tp1.start_date) COL02

323: ,fnd_date.date_to_displaydate(tp1.end_date) COL04
324: ,fnd_date.date_to_displaydate(pa2.effective_date) COL03
325: ,fnd_date.date_to_displaydate(aa1.start_date) COL05
326: ,fnd_date.date_to_displaydate(aa2.end_date) COL06
327: ,fnd_date.date_to_displaydate(tp1.start_date) COL02
328: ,tp1.period_type COL07
329: from pay_all_payrolls_f pp1
330: ,pay_all_payrolls_f pp2
331: ,pay_payroll_actions pa1

Line 366: ,fnd_date.date_to_displaydate(tp.end_date) COL04

362: and pp2.effective_end_date';
363: else
364: l_sql :=
365: 'select tp.period_name COL01
366: ,fnd_date.date_to_displaydate(tp.end_date) COL04
367: ,fnd_date.date_to_displaydate(pa.effective_date) COL03
368: ,fnd_date.date_to_displaydate(aa.start_date) COL05
369: ,fnd_date.date_to_displaydate(aa.end_date) COL06
370: ,fnd_date.date_to_displaydate(tp.start_date) COL02

Line 367: ,fnd_date.date_to_displaydate(pa.effective_date) COL03

363: else
364: l_sql :=
365: 'select tp.period_name COL01
366: ,fnd_date.date_to_displaydate(tp.end_date) COL04
367: ,fnd_date.date_to_displaydate(pa.effective_date) COL03
368: ,fnd_date.date_to_displaydate(aa.start_date) COL05
369: ,fnd_date.date_to_displaydate(aa.end_date) COL06
370: ,fnd_date.date_to_displaydate(tp.start_date) COL02
371: ,tp.period_type COL07

Line 368: ,fnd_date.date_to_displaydate(aa.start_date) COL05

364: l_sql :=
365: 'select tp.period_name COL01
366: ,fnd_date.date_to_displaydate(tp.end_date) COL04
367: ,fnd_date.date_to_displaydate(pa.effective_date) COL03
368: ,fnd_date.date_to_displaydate(aa.start_date) COL05
369: ,fnd_date.date_to_displaydate(aa.end_date) COL06
370: ,fnd_date.date_to_displaydate(tp.start_date) COL02
371: ,tp.period_type COL07
372: from pay_payroll_actions pa

Line 369: ,fnd_date.date_to_displaydate(aa.end_date) COL06

365: 'select tp.period_name COL01
366: ,fnd_date.date_to_displaydate(tp.end_date) COL04
367: ,fnd_date.date_to_displaydate(pa.effective_date) COL03
368: ,fnd_date.date_to_displaydate(aa.start_date) COL05
369: ,fnd_date.date_to_displaydate(aa.end_date) COL06
370: ,fnd_date.date_to_displaydate(tp.start_date) COL02
371: ,tp.period_type COL07
372: from pay_payroll_actions pa
373: ,per_time_periods tp

Line 370: ,fnd_date.date_to_displaydate(tp.start_date) COL02

366: ,fnd_date.date_to_displaydate(tp.end_date) COL04
367: ,fnd_date.date_to_displaydate(pa.effective_date) COL03
368: ,fnd_date.date_to_displaydate(aa.start_date) COL05
369: ,fnd_date.date_to_displaydate(aa.end_date) COL06
370: ,fnd_date.date_to_displaydate(tp.start_date) COL02
371: ,tp.period_type COL07
372: from pay_payroll_actions pa
373: ,per_time_periods tp
374: ,pay_assignment_actions aa

Line 383: ,fnd_date.date_to_displaydate(tp.end_date) COL04

379: end if;
380: else
381: l_sql :=
382: 'select tp.period_name COL01
383: ,fnd_date.date_to_displaydate(tp.end_date) COL04
384: ,fnd_date.date_to_displaydate(pa.effective_date) COL03
385: ,fnd_date.date_to_displaydate(aa.start_date) COL05
386: ,fnd_date.date_to_displaydate(aa.end_date) COL06
387: ,fnd_date.date_to_displaydate(tp.start_date) COL02

Line 384: ,fnd_date.date_to_displaydate(pa.effective_date) COL03

380: else
381: l_sql :=
382: 'select tp.period_name COL01
383: ,fnd_date.date_to_displaydate(tp.end_date) COL04
384: ,fnd_date.date_to_displaydate(pa.effective_date) COL03
385: ,fnd_date.date_to_displaydate(aa.start_date) COL05
386: ,fnd_date.date_to_displaydate(aa.end_date) COL06
387: ,fnd_date.date_to_displaydate(tp.start_date) COL02
388: ,tp.period_type COL07

Line 385: ,fnd_date.date_to_displaydate(aa.start_date) COL05

381: l_sql :=
382: 'select tp.period_name COL01
383: ,fnd_date.date_to_displaydate(tp.end_date) COL04
384: ,fnd_date.date_to_displaydate(pa.effective_date) COL03
385: ,fnd_date.date_to_displaydate(aa.start_date) COL05
386: ,fnd_date.date_to_displaydate(aa.end_date) COL06
387: ,fnd_date.date_to_displaydate(tp.start_date) COL02
388: ,tp.period_type COL07
389: from pay_payroll_actions pa

Line 386: ,fnd_date.date_to_displaydate(aa.end_date) COL06

382: 'select tp.period_name COL01
383: ,fnd_date.date_to_displaydate(tp.end_date) COL04
384: ,fnd_date.date_to_displaydate(pa.effective_date) COL03
385: ,fnd_date.date_to_displaydate(aa.start_date) COL05
386: ,fnd_date.date_to_displaydate(aa.end_date) COL06
387: ,fnd_date.date_to_displaydate(tp.start_date) COL02
388: ,tp.period_type COL07
389: from pay_payroll_actions pa
390: ,per_time_periods tp

Line 387: ,fnd_date.date_to_displaydate(tp.start_date) COL02

383: ,fnd_date.date_to_displaydate(tp.end_date) COL04
384: ,fnd_date.date_to_displaydate(pa.effective_date) COL03
385: ,fnd_date.date_to_displaydate(aa.start_date) COL05
386: ,fnd_date.date_to_displaydate(aa.end_date) COL06
387: ,fnd_date.date_to_displaydate(tp.start_date) COL02
388: ,tp.period_type COL07
389: from pay_payroll_actions pa
390: ,per_time_periods tp
391: ,pay_assignment_actions aa