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

Line 267: SELECT fnd_date.date_to_canonical(

263: WHERE org_information_context = 'MX_TAX_REGISTRATION'
264: AND organization_id = cp_organization_id;
265:
266: CURSOR c_get_last_run_date IS
267: SELECT fnd_date.date_to_canonical(
268: fnd_date.canonical_to_date(
269: pay_mx_utility.get_legi_param_val ('END_DATE',
270: ppa.legislative_parameters)) +
271: 1/(24 * 60 * 60))

Line 268: fnd_date.canonical_to_date(

264: AND organization_id = cp_organization_id;
265:
266: CURSOR c_get_last_run_date IS
267: SELECT fnd_date.date_to_canonical(
268: fnd_date.canonical_to_date(
269: pay_mx_utility.get_legi_param_val ('END_DATE',
270: ppa.legislative_parameters)) +
271: 1/(24 * 60 * 60))
272: FROM pay_payroll_actions ppa

Line 361: ld_end_date := fnd_date.canonical_to_date (g_mag_end_date)+1;

357: /*Bug 8768679 - Added the following code to increase the g_mag_end_date by 1
358: so that it cane be used in the range cursor and it will pick the future
359: hired employee*/
360:
361: ld_end_date := fnd_date.canonical_to_date (g_mag_end_date)+1;
362: l_new_end_date := fnd_date.date_to_canonical (ld_end_date);
363: hr_utility_trace ('End date is '|| l_new_end_date);
364:
365: -- Bug 4518777

Line 362: l_new_end_date := fnd_date.date_to_canonical (ld_end_date);

358: so that it cane be used in the range cursor and it will pick the future
359: hired employee*/
360:
361: ld_end_date := fnd_date.canonical_to_date (g_mag_end_date)+1;
362: l_new_end_date := fnd_date.date_to_canonical (ld_end_date);
363: hr_utility_trace ('End date is '|| l_new_end_date);
364:
365: -- Bug 4518777
366: p_sqlstr := '

Line 373: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(''END_DATE'',

369: FROM pay_assignment_actions paa_arch,
370: pay_payroll_actions ppa_arch
371: WHERE paa_arch.payroll_action_id = ppa_arch.payroll_action_id
372: AND paa_arch.tax_unit_id = '|| g_mag_gre_id ||'/*
373: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(''END_DATE'',
374: ppa_arch.legislative_parameters))
375: BETWEEN fnd_date.canonical_to_date ('''|| g_mag_start_date ||''')
376: AND fnd_date.canonical_to_date ('''|| l_new_end_date ||''')
377: */AND ppa_arch.action_type = ''X''

Line 375: BETWEEN fnd_date.canonical_to_date ('''|| g_mag_start_date ||''')

371: WHERE paa_arch.payroll_action_id = ppa_arch.payroll_action_id
372: AND paa_arch.tax_unit_id = '|| g_mag_gre_id ||'/*
373: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(''END_DATE'',
374: ppa_arch.legislative_parameters))
375: BETWEEN fnd_date.canonical_to_date ('''|| g_mag_start_date ||''')
376: AND fnd_date.canonical_to_date ('''|| l_new_end_date ||''')
377: */AND ppa_arch.action_type = ''X''
378: AND ppa_arch.report_type = ''SS_ARCHIVE''
379: AND ppa_arch.report_qualifier = ''SS_ARCHIVE''

Line 376: AND fnd_date.canonical_to_date ('''|| l_new_end_date ||''')

372: AND paa_arch.tax_unit_id = '|| g_mag_gre_id ||'/*
373: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(''END_DATE'',
374: ppa_arch.legislative_parameters))
375: BETWEEN fnd_date.canonical_to_date ('''|| g_mag_start_date ||''')
376: AND fnd_date.canonical_to_date ('''|| l_new_end_date ||''')
377: */AND ppa_arch.action_type = ''X''
378: AND ppa_arch.report_type = ''SS_ARCHIVE''
379: AND ppa_arch.report_qualifier = ''SS_ARCHIVE''
380: AND ppa_arch.report_category = ''RT''

Line 419: /*AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(

415: AND paa_arch.assignment_id = paf.assignment_id
416: -- Bug 4518777
417: AND paf.person_id BETWEEN p_start_person_id AND p_end_person_id
418: AND paa_arch.tax_unit_id = g_mag_gre_id
419: /*AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(
420: 'END_DATE',
421: ppa_arch.legislative_parameters))
422: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)
423: AND fnd_date.canonical_to_date(g_mag_end_date)*/

Line 422: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)

418: AND paa_arch.tax_unit_id = g_mag_gre_id
419: /*AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(
420: 'END_DATE',
421: ppa_arch.legislative_parameters))
422: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)
423: AND fnd_date.canonical_to_date(g_mag_end_date)*/
424: ----
425: AND paa_arch.assignment_action_id = pai.action_context_id
426: AND (( pai.action_information_category = 'MX SS TRANSACTIONS'

Line 423: AND fnd_date.canonical_to_date(g_mag_end_date)*/

419: /*AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(
420: 'END_DATE',
421: ppa_arch.legislative_parameters))
422: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)
423: AND fnd_date.canonical_to_date(g_mag_end_date)*/
424: ----
425: AND paa_arch.assignment_action_id = pai.action_context_id
426: AND (( pai.action_information_category = 'MX SS TRANSACTIONS'
427: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN

Line 427: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN

423: AND fnd_date.canonical_to_date(g_mag_end_date)*/
424: ----
425: AND paa_arch.assignment_action_id = pai.action_context_id
426: AND (( pai.action_information_category = 'MX SS TRANSACTIONS'
427: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN
428: fnd_date.canonical_to_date (g_mag_start_date)
429: /*Bug 8768679*/
430: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))
431: OR (pai.effective_date BETWEEN

Line 428: fnd_date.canonical_to_date (g_mag_start_date)

424: ----
425: AND paa_arch.assignment_action_id = pai.action_context_id
426: AND (( pai.action_information_category = 'MX SS TRANSACTIONS'
427: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN
428: fnd_date.canonical_to_date (g_mag_start_date)
429: /*Bug 8768679*/
430: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))
431: OR (pai.effective_date BETWEEN
432: fnd_date.canonical_to_date (g_mag_start_date)

Line 430: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))

426: AND (( pai.action_information_category = 'MX SS TRANSACTIONS'
427: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN
428: fnd_date.canonical_to_date (g_mag_start_date)
429: /*Bug 8768679*/
430: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))
431: OR (pai.effective_date BETWEEN
432: fnd_date.canonical_to_date (g_mag_start_date)
433: /*Bug 8768679*/
434: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))

Line 432: fnd_date.canonical_to_date (g_mag_start_date)

428: fnd_date.canonical_to_date (g_mag_start_date)
429: /*Bug 8768679*/
430: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))
431: OR (pai.effective_date BETWEEN
432: fnd_date.canonical_to_date (g_mag_start_date)
433: /*Bug 8768679*/
434: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))
435: /*Bug 8768679*/
436: AND fnd_date.canonical_to_date (pai.action_information2) <=

Line 434: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))

430: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))
431: OR (pai.effective_date BETWEEN
432: fnd_date.canonical_to_date (g_mag_start_date)
433: /*Bug 8768679*/
434: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))
435: /*Bug 8768679*/
436: AND fnd_date.canonical_to_date (pai.action_information2) <=
437: fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))))
438: )

Line 436: AND fnd_date.canonical_to_date (pai.action_information2) <=

432: fnd_date.canonical_to_date (g_mag_start_date)
433: /*Bug 8768679*/
434: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))
435: /*Bug 8768679*/
436: AND fnd_date.canonical_to_date (pai.action_information2) <=
437: fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))))
438: )
439: OR (pai.action_information_category = 'MX SS PERSON INFORMATION'
440: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(

Line 437: fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))))

433: /*Bug 8768679*/
434: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))
435: /*Bug 8768679*/
436: AND fnd_date.canonical_to_date (pai.action_information2) <=
437: fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))))
438: )
439: OR (pai.action_information_category = 'MX SS PERSON INFORMATION'
440: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(
441: 'END_DATE',

Line 440: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(

436: AND fnd_date.canonical_to_date (pai.action_information2) <=
437: fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))))
438: )
439: OR (pai.action_information_category = 'MX SS PERSON INFORMATION'
440: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(
441: 'END_DATE',
442: ppa_arch.legislative_parameters))
443: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)
444: /*Bug 8768679*/

Line 443: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)

439: OR (pai.action_information_category = 'MX SS PERSON INFORMATION'
440: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(
441: 'END_DATE',
442: ppa_arch.legislative_parameters))
443: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)
444: /*Bug 8768679*/
445: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))
446: )
447: )

Line 445: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))

441: 'END_DATE',
442: ppa_arch.legislative_parameters))
443: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)
444: /*Bug 8768679*/
445: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))
446: )
447: )
448: AND paa_arch.tax_unit_id = g_mag_gre_id
449: /*AND NOT EXISTS (SELECT 'X'

Line 491: /*AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(

487: AND paf.person_id = ppr.person_id
488: AND ppr.chunk_number = p_chunk
489: AND ppr.payroll_action_id = p_payroll_action_id
490: AND paa_arch.tax_unit_id = g_mag_gre_id
491: /*AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(
492: 'END_DATE',
493: ppa_arch.legislative_parameters))
494: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)
495: AND fnd_date.canonical_to_date(g_mag_end_date)*/

Line 494: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)

490: AND paa_arch.tax_unit_id = g_mag_gre_id
491: /*AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(
492: 'END_DATE',
493: ppa_arch.legislative_parameters))
494: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)
495: AND fnd_date.canonical_to_date(g_mag_end_date)*/
496: ----
497: AND paa_arch.assignment_action_id = pai.action_context_id
498: AND ((pai.action_information_category = 'MX SS TRANSACTIONS'

Line 495: AND fnd_date.canonical_to_date(g_mag_end_date)*/

491: /*AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(
492: 'END_DATE',
493: ppa_arch.legislative_parameters))
494: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)
495: AND fnd_date.canonical_to_date(g_mag_end_date)*/
496: ----
497: AND paa_arch.assignment_action_id = pai.action_context_id
498: AND ((pai.action_information_category = 'MX SS TRANSACTIONS'
499: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN

Line 499: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN

495: AND fnd_date.canonical_to_date(g_mag_end_date)*/
496: ----
497: AND paa_arch.assignment_action_id = pai.action_context_id
498: AND ((pai.action_information_category = 'MX SS TRANSACTIONS'
499: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN
500: fnd_date.canonical_to_date (g_mag_start_date)
501: /*Bug 8768679*/
502: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))
503: OR (pai.effective_date BETWEEN

Line 500: fnd_date.canonical_to_date (g_mag_start_date)

496: ----
497: AND paa_arch.assignment_action_id = pai.action_context_id
498: AND ((pai.action_information_category = 'MX SS TRANSACTIONS'
499: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN
500: fnd_date.canonical_to_date (g_mag_start_date)
501: /*Bug 8768679*/
502: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))
503: OR (pai.effective_date BETWEEN
504: trunc(fnd_date.canonical_to_date (g_mag_start_date))

Line 502: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))

498: AND ((pai.action_information_category = 'MX SS TRANSACTIONS'
499: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN
500: fnd_date.canonical_to_date (g_mag_start_date)
501: /*Bug 8768679*/
502: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))
503: OR (pai.effective_date BETWEEN
504: trunc(fnd_date.canonical_to_date (g_mag_start_date))
505: /*Bug 8768679*/
506: AND trunc(fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date)))

Line 504: trunc(fnd_date.canonical_to_date (g_mag_start_date))

500: fnd_date.canonical_to_date (g_mag_start_date)
501: /*Bug 8768679*/
502: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))
503: OR (pai.effective_date BETWEEN
504: trunc(fnd_date.canonical_to_date (g_mag_start_date))
505: /*Bug 8768679*/
506: AND trunc(fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date)))
507: /*Bug 8768679*/
508: AND fnd_date.canonical_to_date (pai.action_information2) <=

Line 506: AND trunc(fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date)))

502: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))
503: OR (pai.effective_date BETWEEN
504: trunc(fnd_date.canonical_to_date (g_mag_start_date))
505: /*Bug 8768679*/
506: AND trunc(fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date)))
507: /*Bug 8768679*/
508: AND fnd_date.canonical_to_date (pai.action_information2) <=
509: fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))))
510: )

Line 508: AND fnd_date.canonical_to_date (pai.action_information2) <=

504: trunc(fnd_date.canonical_to_date (g_mag_start_date))
505: /*Bug 8768679*/
506: AND trunc(fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date)))
507: /*Bug 8768679*/
508: AND fnd_date.canonical_to_date (pai.action_information2) <=
509: fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))))
510: )
511: OR (pai.action_information_category = 'MX SS PERSON INFORMATION'
512: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(

Line 509: fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))))

505: /*Bug 8768679*/
506: AND trunc(fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date)))
507: /*Bug 8768679*/
508: AND fnd_date.canonical_to_date (pai.action_information2) <=
509: fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))))
510: )
511: OR (pai.action_information_category = 'MX SS PERSON INFORMATION'
512: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(
513: 'END_DATE',

Line 512: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(

508: AND fnd_date.canonical_to_date (pai.action_information2) <=
509: fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))))
510: )
511: OR (pai.action_information_category = 'MX SS PERSON INFORMATION'
512: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(
513: 'END_DATE',
514: ppa_arch.legislative_parameters))
515: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)
516: /*Bug 8768679*/

Line 515: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)

511: OR (pai.action_information_category = 'MX SS PERSON INFORMATION'
512: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(
513: 'END_DATE',
514: ppa_arch.legislative_parameters))
515: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)
516: /*Bug 8768679*/
517: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))
518: )
519: )

Line 517: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))

513: 'END_DATE',
514: ppa_arch.legislative_parameters))
515: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)
516: /*Bug 8768679*/
517: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))
518: )
519: )
520: AND paa_arch.tax_unit_id = g_mag_gre_id
521: /*AND NOT EXISTS (SELECT 'X'

Line 557: AND fnd_date.canonical_to_date(pay_mx_utility.get_legi_param_val(

553: AND ppa.action_status = 'C'
554: AND pay_mx_utility.get_legi_param_val('GRE',
555: ppa.legislative_parameters) =
556: g_mag_gre_id
557: AND fnd_date.canonical_to_date(pay_mx_utility.get_legi_param_val(
558: 'END_DATE',
559: ppa.legislative_parameters)) >
560: fnd_date.canonical_to_date(g_mag_end_date);
561:

Line 560: fnd_date.canonical_to_date(g_mag_end_date);

556: g_mag_gre_id
557: AND fnd_date.canonical_to_date(pay_mx_utility.get_legi_param_val(
558: 'END_DATE',
559: ppa.legislative_parameters)) >
560: fnd_date.canonical_to_date(g_mag_end_date);
561:
562: /*Bug 8768679 - The following cursor has been added to find out if
563: the Archiver Assignment action has been already locked in pay_action_interlocks*/
564: CURSOR c_assg_action_exist (p_arch_asg_act NUMBER) IS

Line 627: ld_end_date := fnd_date.canonical_to_date (g_mag_end_date)+1;

623:
624: /*Bug 8768679 - Added the following code to increase the g_mag_end_date by 1
625: so that it cane be used in the action creation cursors */
626:
627: ld_end_date := fnd_date.canonical_to_date (g_mag_end_date)+1;
628: l_new_end_date := fnd_date.date_to_canonical (ld_end_date);
629: hr_utility_trace ('End date is '|| l_new_end_date);
630:
631: /* Raise an error if magtape is run in FULL mode and future magtape runs

Line 628: l_new_end_date := fnd_date.date_to_canonical (ld_end_date);

624: /*Bug 8768679 - Added the following code to increase the g_mag_end_date by 1
625: so that it cane be used in the action creation cursors */
626:
627: ld_end_date := fnd_date.canonical_to_date (g_mag_end_date)+1;
628: l_new_end_date := fnd_date.date_to_canonical (ld_end_date);
629: hr_utility_trace ('End date is '|| l_new_end_date);
630:
631: /* Raise an error if magtape is run in FULL mode and future magtape runs
632: already exist */

Line 788: AND fnd_date.canonical_to_date(pai.action_information10)

784: pay_action_interlocks lck
785: WHERE pai.action_context_id = paa_arch.assignment_action_id
786: AND paf.assignment_id = paa_arch.assignment_id
787: /*Bug 8768679*/
788: AND fnd_date.canonical_to_date(pai.action_information10)
789: BETWEEN paf.effective_start_date
790: AND paf.effective_end_date
791: AND paa_arch.assignment_action_id = lck.locked_action_id
792: AND lck.locking_action_id = cp_assignment_action_id

Line 819: AND fnd_date.canonical_to_date (pai.action_information2) >= fnd_date.canonical_to_date(cp_imp_date)

815: pay_action_interlocks lck
816: WHERE pai.action_context_id = paa_arch.assignment_action_id
817: AND paf.assignment_id = paa_arch.assignment_id
818: --Bug 7185703
819: AND fnd_date.canonical_to_date (pai.action_information2) >= fnd_date.canonical_to_date(cp_imp_date)
820: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN
821: fnd_date.canonical_to_date (g_mag_start_date)
822: /*Bug 8768679*/
823: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_mag_end_date))

Line 820: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN

816: WHERE pai.action_context_id = paa_arch.assignment_action_id
817: AND paf.assignment_id = paa_arch.assignment_id
818: --Bug 7185703
819: AND fnd_date.canonical_to_date (pai.action_information2) >= fnd_date.canonical_to_date(cp_imp_date)
820: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN
821: fnd_date.canonical_to_date (g_mag_start_date)
822: /*Bug 8768679*/
823: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_mag_end_date))
824: OR (pai.effective_date BETWEEN

Line 821: fnd_date.canonical_to_date (g_mag_start_date)

817: AND paf.assignment_id = paa_arch.assignment_id
818: --Bug 7185703
819: AND fnd_date.canonical_to_date (pai.action_information2) >= fnd_date.canonical_to_date(cp_imp_date)
820: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN
821: fnd_date.canonical_to_date (g_mag_start_date)
822: /*Bug 8768679*/
823: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_mag_end_date))
824: OR (pai.effective_date BETWEEN
825: fnd_date.canonical_to_date (g_mag_start_date)

Line 823: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_mag_end_date))

819: AND fnd_date.canonical_to_date (pai.action_information2) >= fnd_date.canonical_to_date(cp_imp_date)
820: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN
821: fnd_date.canonical_to_date (g_mag_start_date)
822: /*Bug 8768679*/
823: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_mag_end_date))
824: OR (pai.effective_date BETWEEN
825: fnd_date.canonical_to_date (g_mag_start_date)
826: /*Bug 8768679*/
827: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_mag_end_date))

Line 825: fnd_date.canonical_to_date (g_mag_start_date)

821: fnd_date.canonical_to_date (g_mag_start_date)
822: /*Bug 8768679*/
823: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_mag_end_date))
824: OR (pai.effective_date BETWEEN
825: fnd_date.canonical_to_date (g_mag_start_date)
826: /*Bug 8768679*/
827: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_mag_end_date))
828: /*Bug 8768679*/
829: AND fnd_date.canonical_to_date (pai.action_information2) <=

Line 827: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_mag_end_date))

823: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_mag_end_date))
824: OR (pai.effective_date BETWEEN
825: fnd_date.canonical_to_date (g_mag_start_date)
826: /*Bug 8768679*/
827: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_mag_end_date))
828: /*Bug 8768679*/
829: AND fnd_date.canonical_to_date (pai.action_information2) <=
830: fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_mag_end_date))))
831: AND fnd_date.canonical_to_date(pai.action_information2)

Line 829: AND fnd_date.canonical_to_date (pai.action_information2) <=

825: fnd_date.canonical_to_date (g_mag_start_date)
826: /*Bug 8768679*/
827: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_mag_end_date))
828: /*Bug 8768679*/
829: AND fnd_date.canonical_to_date (pai.action_information2) <=
830: fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_mag_end_date))))
831: AND fnd_date.canonical_to_date(pai.action_information2)
832: BETWEEN paf.effective_start_date
833: AND paf.effective_end_date

Line 830: fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_mag_end_date))))

826: /*Bug 8768679*/
827: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_mag_end_date))
828: /*Bug 8768679*/
829: AND fnd_date.canonical_to_date (pai.action_information2) <=
830: fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_mag_end_date))))
831: AND fnd_date.canonical_to_date(pai.action_information2)
832: BETWEEN paf.effective_start_date
833: AND paf.effective_end_date
834: AND paa_arch.assignment_action_id = lck.locked_action_id

Line 831: AND fnd_date.canonical_to_date(pai.action_information2)

827: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_mag_end_date))
828: /*Bug 8768679*/
829: AND fnd_date.canonical_to_date (pai.action_information2) <=
830: fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_mag_end_date))))
831: AND fnd_date.canonical_to_date(pai.action_information2)
832: BETWEEN paf.effective_start_date
833: AND paf.effective_end_date
834: AND paa_arch.assignment_action_id = lck.locked_action_id
835: AND lck.locking_action_id = cp_assignment_action_id

Line 839: ORDER BY fnd_date.canonical_to_date (pai.action_information2), -- tran dt

835: AND lck.locking_action_id = cp_assignment_action_id
836: AND pai.action_context_type = 'AAP'
837: AND pai.action_information_category = 'MX SS TRANSACTIONS'
838:
839: ORDER BY fnd_date.canonical_to_date (pai.action_information2), -- tran dt
840: DECODE (pai.action_information4,
841: '08', 1,
842: '07', 2,
843: '02', 3),

Line 854: SELECT fnd_date.canonical_to_date(pai.action_information2) -- tran date

850: CURSOR csr_tran_exists (cp_mag_asact_id number,
851: cp_person_id varchar2,
852: cp_tran_type varchar2,
853: cp_tran_dt date) IS
854: SELECT fnd_date.canonical_to_date(pai.action_information2) -- tran date
855: FROM pay_assignment_actions paa_mag,
856: pay_payroll_actions ppa_mag,
857: pay_assignment_actions paa_mag_prev,
858: pay_payroll_actions ppa_mag_prev,

Line 874: AND ((fnd_date.canonical_to_date (pai.action_information2) >

870: AND paa_mag.assignment_action_id = cp_mag_asact_id
871: AND pai.action_information1 = cp_person_id -- person ID
872: AND pai.action_information4 = cp_tran_type -- transaction type
873: AND nvl(pai.action_information10, 'N') <> 'Y' -- do not report flag
874: AND ((fnd_date.canonical_to_date (pai.action_information2) >
875: cp_tran_dt) OR
876: (cp_tran_dt IS NULL))
877: AND pai.action_context_type = 'AAP'
878: AND pai.action_information_category = 'MX SS TRANSACTIONS'

Line 895: fnd_date.canonical_to_date(g_mag_end_date)

891:
892: CURSOR csr_asg_actions (cp_person_id number) IS
893: SELECT fnd_number.canonical_to_number(
894: pay_magtape_generic.get_parameter_value ('TRANSFER_ACT_ID')),
895: fnd_date.canonical_to_date(g_mag_end_date)
896: FROM DUAL
897: UNION
898: SELECT paa.assignment_action_id,
899: fnd_date.canonical_to_date(

Line 899: fnd_date.canonical_to_date(

895: fnd_date.canonical_to_date(g_mag_end_date)
896: FROM DUAL
897: UNION
898: SELECT paa.assignment_action_id,
899: fnd_date.canonical_to_date(
900: pay_mx_utility.get_legi_param_val('END_DATE',
901: ppa.legislative_parameters))
902: FROM pay_payroll_actions ppa,
903: pay_assignment_actions paa,

Line 908: AND fnd_date.canonical_to_date(

904: per_assignments_f paf
905: WHERE ppa.payroll_action_id = paa.payroll_action_id
906: AND paa.assignment_id = paf.assignment_id
907: AND paf.person_id = cp_person_id
908: AND fnd_date.canonical_to_date(
909: pay_mx_utility.get_legi_param_val('END_DATE',
910: ppa.legislative_parameters))
911: BETWEEN paf.effective_start_date AND paf.effective_end_date
912: AND ppa.action_type = 'X'

Line 920: AND cp_curr_date > fnd_date.canonical_to_date(

916: AND ppa.action_status = 'C'
917: /*AND cp_gre_id = fnd_number.canonical_to_number(
918: pay_mx_utility.get_legi_param_val('GRE',
919: ppa.legislative_parameters))
920: AND cp_curr_date > fnd_date.canonical_to_date(
921: pay_mx_utility.get_legi_param_val('END_DATE',
922: ppa.legislative_parameters))*/
923: AND fnd_number.canonical_to_number(g_mag_gre_id) =
924: fnd_number.canonical_to_number(

Line 927: AND fnd_date.canonical_to_date(g_mag_end_date) >

923: AND fnd_number.canonical_to_number(g_mag_gre_id) =
924: fnd_number.canonical_to_number(
925: pay_mx_utility.get_legi_param_val('GRE',
926: ppa.legislative_parameters))
927: AND fnd_date.canonical_to_date(g_mag_end_date) >
928: fnd_date.canonical_to_date(
929: pay_mx_utility.get_legi_param_val('END_DATE',
930: ppa.legislative_parameters))
931: ORDER BY 2 DESC;

Line 928: fnd_date.canonical_to_date(

924: fnd_number.canonical_to_number(
925: pay_mx_utility.get_legi_param_val('GRE',
926: ppa.legislative_parameters))
927: AND fnd_date.canonical_to_date(g_mag_end_date) >
928: fnd_date.canonical_to_date(
929: pay_mx_utility.get_legi_param_val('END_DATE',
930: ppa.legislative_parameters))
931: ORDER BY 2 DESC;
932:

Line 956: AND fnd_date.canonical_to_date(g_mag_end_date) >

952: AND fnd_number.canonical_to_number(g_mag_gre_id) =
953: fnd_number.canonical_to_number(
954: pay_mx_utility.get_legi_param_val('GRE',
955: ppa_sua.legislative_parameters))
956: AND fnd_date.canonical_to_date(g_mag_end_date) >
957: fnd_date.canonical_to_date(
958: pay_mx_utility.get_legi_param_val('END_DATE',
959: ppa_sua.legislative_parameters))
960: -- Bug 5998981

Line 957: fnd_date.canonical_to_date(

953: fnd_number.canonical_to_number(
954: pay_mx_utility.get_legi_param_val('GRE',
955: ppa_sua.legislative_parameters))
956: AND fnd_date.canonical_to_date(g_mag_end_date) >
957: fnd_date.canonical_to_date(
958: pay_mx_utility.get_legi_param_val('END_DATE',
959: ppa_sua.legislative_parameters))
960: -- Bug 5998981
961: AND DECODE (pai.action_information_category,

Line 963: fnd_date.canonical_to_date(pai.action_information2),

959: ppa_sua.legislative_parameters))
960: -- Bug 5998981
961: AND DECODE (pai.action_information_category,
962: 'MX SS TRANSACTIONS',
963: fnd_date.canonical_to_date(pai.action_information2),
964: hr_general.start_of_time)
965: BETWEEN fnd_date.canonical_to_date(
966: pay_mx_utility.get_legi_param_val('START_DATE',
967: ppa_sua.legislative_parameters))

Line 965: BETWEEN fnd_date.canonical_to_date(

961: AND DECODE (pai.action_information_category,
962: 'MX SS TRANSACTIONS',
963: fnd_date.canonical_to_date(pai.action_information2),
964: hr_general.start_of_time)
965: BETWEEN fnd_date.canonical_to_date(
966: pay_mx_utility.get_legi_param_val('START_DATE',
967: ppa_sua.legislative_parameters))
968: AND fnd_date.canonical_to_date(
969: pay_mx_utility.get_legi_param_val('END_DATE',

Line 968: AND fnd_date.canonical_to_date(

964: hr_general.start_of_time)
965: BETWEEN fnd_date.canonical_to_date(
966: pay_mx_utility.get_legi_param_val('START_DATE',
967: ppa_sua.legislative_parameters))
968: AND fnd_date.canonical_to_date(
969: pay_mx_utility.get_legi_param_val('END_DATE',
970: ppa_sua.legislative_parameters))
971: ORDER BY fnd_date.canonical_to_date (pai.action_information2) DESC;
972:

Line 971: ORDER BY fnd_date.canonical_to_date (pai.action_information2) DESC;

967: ppa_sua.legislative_parameters))
968: AND fnd_date.canonical_to_date(
969: pay_mx_utility.get_legi_param_val('END_DATE',
970: ppa_sua.legislative_parameters))
971: ORDER BY fnd_date.canonical_to_date (pai.action_information2) DESC;
972:
973: CURSOR c_get_imp_date (cp_gre_id NUMBER) IS
974: SELECT org_information6
975: FROM hr_organization_information

Line 1027: ld_end_date := fnd_date.canonical_to_date (g_mag_end_date)+1;

1023: ln_assignment_action_id := pay_magtape_generic.get_parameter_value
1024: ('TRANSFER_ACT_ID');
1025: hr_utility_trace ('Processing asg action '|| ln_assignment_action_id);
1026:
1027: ld_end_date := fnd_date.canonical_to_date (g_mag_end_date)+1;
1028: l_new_end_date := fnd_date.date_to_canonical (ld_end_date);
1029: hr_utility_trace ('End date is '|| l_new_end_date);
1030:
1031: OPEN c_get_bus_grp_id;

Line 1028: l_new_end_date := fnd_date.date_to_canonical (ld_end_date);

1024: ('TRANSFER_ACT_ID');
1025: hr_utility_trace ('Processing asg action '|| ln_assignment_action_id);
1026:
1027: ld_end_date := fnd_date.canonical_to_date (g_mag_end_date)+1;
1028: l_new_end_date := fnd_date.date_to_canonical (ld_end_date);
1029: hr_utility_trace ('End date is '|| l_new_end_date);
1030:
1031: OPEN c_get_bus_grp_id;
1032: FETCH c_get_bus_grp_id INTO ln_business_group;

Line 1044: SELECT fnd_date.date_to_canonical(MIN(creation_date))

1040: FETCH c_get_imp_date INTO ld_imp_date;
1041: CLOSE c_get_imp_date;
1042: hr_utility_trace ('ld_imp_date '|| ld_imp_date);
1043:
1044: SELECT fnd_date.date_to_canonical(MIN(creation_date))
1045: INTO ld_event_strt_date
1046: FROM pay_process_events ppe
1047: WHERE EXISTS
1048: (SELECT 1

Line 1054: IF fnd_date.canonical_to_date(ld_event_strt_date) >= fnd_date.canonical_to_date(NVL(ld_imp_date,ld_event_strt_date)) THEN

1050: WHERE table_name IN ('PER_ALL_PEOPLE_F','PER_ALL_ASSIGNMENTS_F','PAY_ELEMENT_ENTRIES_F','PAY_ELEMENT_ENTRY_VALUES_F')
1051: AND ppe.event_update_id = peu.event_update_id
1052: );
1053:
1054: IF fnd_date.canonical_to_date(ld_event_strt_date) >= fnd_date.canonical_to_date(NVL(ld_imp_date,ld_event_strt_date)) THEN
1055: ld_imp_date := ld_event_strt_date;
1056: END IF;
1057:
1058: hr_utility_trace ('ld_event_strt_date '|| ld_event_strt_date);

Line 1201: fnd_date.date_to_canonical(ld_tran_dt));

1197: FETCH csr_tran_exists INTO ld_tran_dt;
1198: CLOSE csr_tran_exists;
1199:
1200: hr_utility_trace('Above transaction was reported on '||
1201: fnd_date.date_to_canonical(ld_tran_dt));
1202:
1203: IF ld_tran_dt IS NOT NULL THEN
1204: ld_tran_dt := NULL;
1205: IF lv_tran_type = '08' THEN

Line 1222: fnd_date.date_to_canonical(ld_tran_dt));

1218: CLOSE csr_tran_exists;
1219:
1220: hr_utility_trace('Counter transaction of above '||
1221: 'transaction was reported on '||
1222: fnd_date.date_to_canonical(ld_tran_dt));
1223: IF ld_tran_dt IS NULL THEN
1224: hr_utility_trace('Suppressing above transaction');
1225: lv_show_curr_trans := 'N';
1226: END IF;

Line 1243: fnd_date.canonical_to_date(g_mag_end_date),

1239: CLOSE get_emp_trans;
1240: per_mx_ss_affiliation.process_transactions (
1241: lv_person_id,
1242: fnd_number.canonical_to_number(g_mag_gre_id),
1243: fnd_date.canonical_to_date(g_mag_end_date),
1244: 'SUA_MAG',
1245: 'SUA_MAG',
1246: 'RT',
1247: lt_tran);