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.

[Home] [Help]

APPS.PAY_MX_SUA_MAG dependencies on FND_DATE

Line 249: SELECT fnd_date.date_to_canonical(

245: WHERE org_information_context = 'MX_TAX_REGISTRATION'
246: AND organization_id = cp_organization_id;
247:
248: CURSOR c_get_last_run_date IS
249: SELECT fnd_date.date_to_canonical(
250: fnd_date.canonical_to_date(
251: pay_mx_utility.get_legi_param_val ('END_DATE',
252: ppa.legislative_parameters)) +
253: 1/(24 * 60 * 60))

Line 250: fnd_date.canonical_to_date(

246: AND organization_id = cp_organization_id;
247:
248: CURSOR c_get_last_run_date IS
249: SELECT fnd_date.date_to_canonical(
250: fnd_date.canonical_to_date(
251: pay_mx_utility.get_legi_param_val ('END_DATE',
252: ppa.legislative_parameters)) +
253: 1/(24 * 60 * 60))
254: FROM pay_payroll_actions ppa

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

341: FROM pay_assignment_actions paa_arch,
342: pay_payroll_actions ppa_arch
343: WHERE paa_arch.payroll_action_id = ppa_arch.payroll_action_id
344: AND paa_arch.tax_unit_id = '|| g_mag_gre_id ||'/*
345: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(''END_DATE'',
346: ppa_arch.legislative_parameters))
347: BETWEEN fnd_date.canonical_to_date ('''|| g_mag_start_date ||''')
348: AND fnd_date.canonical_to_date ('''|| g_mag_end_date ||''')
349: */AND ppa_arch.action_type = ''X''

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

343: WHERE paa_arch.payroll_action_id = ppa_arch.payroll_action_id
344: AND paa_arch.tax_unit_id = '|| g_mag_gre_id ||'/*
345: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(''END_DATE'',
346: ppa_arch.legislative_parameters))
347: BETWEEN fnd_date.canonical_to_date ('''|| g_mag_start_date ||''')
348: AND fnd_date.canonical_to_date ('''|| g_mag_end_date ||''')
349: */AND ppa_arch.action_type = ''X''
350: AND ppa_arch.report_type = ''SS_ARCHIVE''
351: AND ppa_arch.report_qualifier = ''SS_ARCHIVE''

Line 348: AND fnd_date.canonical_to_date ('''|| g_mag_end_date ||''')

344: AND paa_arch.tax_unit_id = '|| g_mag_gre_id ||'/*
345: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(''END_DATE'',
346: ppa_arch.legislative_parameters))
347: BETWEEN fnd_date.canonical_to_date ('''|| g_mag_start_date ||''')
348: AND fnd_date.canonical_to_date ('''|| g_mag_end_date ||''')
349: */AND ppa_arch.action_type = ''X''
350: AND ppa_arch.report_type = ''SS_ARCHIVE''
351: AND ppa_arch.report_qualifier = ''SS_ARCHIVE''
352: AND ppa_arch.report_category = ''RT''

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

386: AND paa_arch.assignment_id = paf.assignment_id
387: -- Bug 4518777
388: AND paf.person_id BETWEEN p_start_person_id AND p_end_person_id
389: AND paa_arch.tax_unit_id = g_mag_gre_id
390: /*AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(
391: 'END_DATE',
392: ppa_arch.legislative_parameters))
393: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)
394: AND fnd_date.canonical_to_date(g_mag_end_date)*/

Line 393: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)

389: AND paa_arch.tax_unit_id = g_mag_gre_id
390: /*AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(
391: 'END_DATE',
392: ppa_arch.legislative_parameters))
393: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)
394: AND fnd_date.canonical_to_date(g_mag_end_date)*/
395: ----
396: AND paa_arch.assignment_action_id = pai.action_context_id
397: AND (( pai.action_information_category = 'MX SS TRANSACTIONS'

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

390: /*AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(
391: 'END_DATE',
392: ppa_arch.legislative_parameters))
393: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)
394: AND fnd_date.canonical_to_date(g_mag_end_date)*/
395: ----
396: AND paa_arch.assignment_action_id = pai.action_context_id
397: AND (( pai.action_information_category = 'MX SS TRANSACTIONS'
398: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN

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

394: AND fnd_date.canonical_to_date(g_mag_end_date)*/
395: ----
396: AND paa_arch.assignment_action_id = pai.action_context_id
397: AND (( pai.action_information_category = 'MX SS TRANSACTIONS'
398: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN
399: fnd_date.canonical_to_date (g_mag_start_date)
400: AND fnd_date.canonical_to_date (g_mag_end_date)
401: OR (pai.effective_date BETWEEN
402: fnd_date.canonical_to_date (g_mag_start_date)

Line 399: fnd_date.canonical_to_date (g_mag_start_date)

395: ----
396: AND paa_arch.assignment_action_id = pai.action_context_id
397: AND (( pai.action_information_category = 'MX SS TRANSACTIONS'
398: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN
399: fnd_date.canonical_to_date (g_mag_start_date)
400: AND fnd_date.canonical_to_date (g_mag_end_date)
401: OR (pai.effective_date BETWEEN
402: fnd_date.canonical_to_date (g_mag_start_date)
403: AND fnd_date.canonical_to_date (g_mag_end_date)

Line 400: AND fnd_date.canonical_to_date (g_mag_end_date)

396: AND paa_arch.assignment_action_id = pai.action_context_id
397: AND (( pai.action_information_category = 'MX SS TRANSACTIONS'
398: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN
399: fnd_date.canonical_to_date (g_mag_start_date)
400: AND fnd_date.canonical_to_date (g_mag_end_date)
401: OR (pai.effective_date BETWEEN
402: fnd_date.canonical_to_date (g_mag_start_date)
403: AND fnd_date.canonical_to_date (g_mag_end_date)
404: AND fnd_date.canonical_to_date (pai.action_information2) <=

Line 402: fnd_date.canonical_to_date (g_mag_start_date)

398: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN
399: fnd_date.canonical_to_date (g_mag_start_date)
400: AND fnd_date.canonical_to_date (g_mag_end_date)
401: OR (pai.effective_date BETWEEN
402: fnd_date.canonical_to_date (g_mag_start_date)
403: AND fnd_date.canonical_to_date (g_mag_end_date)
404: AND fnd_date.canonical_to_date (pai.action_information2) <=
405: fnd_date.canonical_to_date (g_mag_end_date)))
406: )

Line 403: AND fnd_date.canonical_to_date (g_mag_end_date)

399: fnd_date.canonical_to_date (g_mag_start_date)
400: AND fnd_date.canonical_to_date (g_mag_end_date)
401: OR (pai.effective_date BETWEEN
402: fnd_date.canonical_to_date (g_mag_start_date)
403: AND fnd_date.canonical_to_date (g_mag_end_date)
404: AND fnd_date.canonical_to_date (pai.action_information2) <=
405: fnd_date.canonical_to_date (g_mag_end_date)))
406: )
407: OR pai.action_information_category = 'MX SS PERSON INFORMATION'

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

400: AND fnd_date.canonical_to_date (g_mag_end_date)
401: OR (pai.effective_date BETWEEN
402: fnd_date.canonical_to_date (g_mag_start_date)
403: AND fnd_date.canonical_to_date (g_mag_end_date)
404: AND fnd_date.canonical_to_date (pai.action_information2) <=
405: fnd_date.canonical_to_date (g_mag_end_date)))
406: )
407: OR pai.action_information_category = 'MX SS PERSON INFORMATION'
408: )

Line 405: fnd_date.canonical_to_date (g_mag_end_date)))

401: OR (pai.effective_date BETWEEN
402: fnd_date.canonical_to_date (g_mag_start_date)
403: AND fnd_date.canonical_to_date (g_mag_end_date)
404: AND fnd_date.canonical_to_date (pai.action_information2) <=
405: fnd_date.canonical_to_date (g_mag_end_date)))
406: )
407: OR pai.action_information_category = 'MX SS PERSON INFORMATION'
408: )
409: AND paa_arch.tax_unit_id = g_mag_gre_id

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

447: AND paf.person_id = ppr.person_id
448: AND ppr.chunk_number = p_chunk
449: AND ppr.payroll_action_id = p_payroll_action_id
450: AND paa_arch.tax_unit_id = g_mag_gre_id
451: /*AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(
452: 'END_DATE',
453: ppa_arch.legislative_parameters))
454: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)
455: AND fnd_date.canonical_to_date(g_mag_end_date)*/

Line 454: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)

450: AND paa_arch.tax_unit_id = g_mag_gre_id
451: /*AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(
452: 'END_DATE',
453: ppa_arch.legislative_parameters))
454: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)
455: AND fnd_date.canonical_to_date(g_mag_end_date)*/
456: ----
457: AND paa_arch.assignment_action_id = pai.action_context_id
458: AND ((pai.action_information_category = 'MX SS TRANSACTIONS'

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

451: /*AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(
452: 'END_DATE',
453: ppa_arch.legislative_parameters))
454: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)
455: AND fnd_date.canonical_to_date(g_mag_end_date)*/
456: ----
457: AND paa_arch.assignment_action_id = pai.action_context_id
458: AND ((pai.action_information_category = 'MX SS TRANSACTIONS'
459: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN

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

455: AND fnd_date.canonical_to_date(g_mag_end_date)*/
456: ----
457: AND paa_arch.assignment_action_id = pai.action_context_id
458: AND ((pai.action_information_category = 'MX SS TRANSACTIONS'
459: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN
460: fnd_date.canonical_to_date (g_mag_start_date)
461: AND fnd_date.canonical_to_date (g_mag_end_date)
462: OR (pai.effective_date BETWEEN
463: fnd_date.canonical_to_date (g_mag_start_date)

Line 460: fnd_date.canonical_to_date (g_mag_start_date)

456: ----
457: AND paa_arch.assignment_action_id = pai.action_context_id
458: AND ((pai.action_information_category = 'MX SS TRANSACTIONS'
459: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN
460: fnd_date.canonical_to_date (g_mag_start_date)
461: AND fnd_date.canonical_to_date (g_mag_end_date)
462: OR (pai.effective_date BETWEEN
463: fnd_date.canonical_to_date (g_mag_start_date)
464: AND fnd_date.canonical_to_date (g_mag_end_date)

Line 461: AND fnd_date.canonical_to_date (g_mag_end_date)

457: AND paa_arch.assignment_action_id = pai.action_context_id
458: AND ((pai.action_information_category = 'MX SS TRANSACTIONS'
459: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN
460: fnd_date.canonical_to_date (g_mag_start_date)
461: AND fnd_date.canonical_to_date (g_mag_end_date)
462: OR (pai.effective_date BETWEEN
463: fnd_date.canonical_to_date (g_mag_start_date)
464: AND fnd_date.canonical_to_date (g_mag_end_date)
465: AND fnd_date.canonical_to_date (pai.action_information2) <=

Line 463: fnd_date.canonical_to_date (g_mag_start_date)

459: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN
460: fnd_date.canonical_to_date (g_mag_start_date)
461: AND fnd_date.canonical_to_date (g_mag_end_date)
462: OR (pai.effective_date BETWEEN
463: fnd_date.canonical_to_date (g_mag_start_date)
464: AND fnd_date.canonical_to_date (g_mag_end_date)
465: AND fnd_date.canonical_to_date (pai.action_information2) <=
466: fnd_date.canonical_to_date (g_mag_end_date)))
467: )

Line 464: AND fnd_date.canonical_to_date (g_mag_end_date)

460: fnd_date.canonical_to_date (g_mag_start_date)
461: AND fnd_date.canonical_to_date (g_mag_end_date)
462: OR (pai.effective_date BETWEEN
463: fnd_date.canonical_to_date (g_mag_start_date)
464: AND fnd_date.canonical_to_date (g_mag_end_date)
465: AND fnd_date.canonical_to_date (pai.action_information2) <=
466: fnd_date.canonical_to_date (g_mag_end_date)))
467: )
468: OR pai.action_information_category = 'MX SS PERSON INFORMATION'

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

461: AND fnd_date.canonical_to_date (g_mag_end_date)
462: OR (pai.effective_date BETWEEN
463: fnd_date.canonical_to_date (g_mag_start_date)
464: AND fnd_date.canonical_to_date (g_mag_end_date)
465: AND fnd_date.canonical_to_date (pai.action_information2) <=
466: fnd_date.canonical_to_date (g_mag_end_date)))
467: )
468: OR pai.action_information_category = 'MX SS PERSON INFORMATION'
469: )

Line 466: fnd_date.canonical_to_date (g_mag_end_date)))

462: OR (pai.effective_date BETWEEN
463: fnd_date.canonical_to_date (g_mag_start_date)
464: AND fnd_date.canonical_to_date (g_mag_end_date)
465: AND fnd_date.canonical_to_date (pai.action_information2) <=
466: fnd_date.canonical_to_date (g_mag_end_date)))
467: )
468: OR pai.action_information_category = 'MX SS PERSON INFORMATION'
469: )
470: AND paa_arch.tax_unit_id = g_mag_gre_id

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

503: AND ppa.action_status = 'C'
504: AND pay_mx_utility.get_legi_param_val('GRE',
505: ppa.legislative_parameters) =
506: g_mag_gre_id
507: AND fnd_date.canonical_to_date(pay_mx_utility.get_legi_param_val(
508: 'END_DATE',
509: ppa.legislative_parameters)) >
510: fnd_date.canonical_to_date(g_mag_end_date);
511:

Line 510: fnd_date.canonical_to_date(g_mag_end_date);

506: g_mag_gre_id
507: AND fnd_date.canonical_to_date(pay_mx_utility.get_legi_param_val(
508: 'END_DATE',
509: ppa.legislative_parameters)) >
510: fnd_date.canonical_to_date(g_mag_end_date);
511:
512:
513: TYPE num_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
514: lt_arch_act num_tab;

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

703: pay_action_interlocks lck
704: WHERE pai.action_context_id = paa_arch.assignment_action_id
705: AND paf.assignment_id = paa_arch.assignment_id
706: --Bug 7185703
707: AND fnd_date.canonical_to_date (pai.action_information2) >= fnd_date.canonical_to_date(cp_imp_date)
708: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN
709: fnd_date.canonical_to_date (g_mag_start_date)
710: AND fnd_date.canonical_to_date (g_mag_end_date)
711: OR (pai.effective_date BETWEEN

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

704: WHERE pai.action_context_id = paa_arch.assignment_action_id
705: AND paf.assignment_id = paa_arch.assignment_id
706: --Bug 7185703
707: AND fnd_date.canonical_to_date (pai.action_information2) >= fnd_date.canonical_to_date(cp_imp_date)
708: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN
709: fnd_date.canonical_to_date (g_mag_start_date)
710: AND fnd_date.canonical_to_date (g_mag_end_date)
711: OR (pai.effective_date BETWEEN
712: fnd_date.canonical_to_date (g_mag_start_date)

Line 709: fnd_date.canonical_to_date (g_mag_start_date)

705: AND paf.assignment_id = paa_arch.assignment_id
706: --Bug 7185703
707: AND fnd_date.canonical_to_date (pai.action_information2) >= fnd_date.canonical_to_date(cp_imp_date)
708: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN
709: fnd_date.canonical_to_date (g_mag_start_date)
710: AND fnd_date.canonical_to_date (g_mag_end_date)
711: OR (pai.effective_date BETWEEN
712: fnd_date.canonical_to_date (g_mag_start_date)
713: AND fnd_date.canonical_to_date (g_mag_end_date)

Line 710: AND fnd_date.canonical_to_date (g_mag_end_date)

706: --Bug 7185703
707: AND fnd_date.canonical_to_date (pai.action_information2) >= fnd_date.canonical_to_date(cp_imp_date)
708: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN
709: fnd_date.canonical_to_date (g_mag_start_date)
710: AND fnd_date.canonical_to_date (g_mag_end_date)
711: OR (pai.effective_date BETWEEN
712: fnd_date.canonical_to_date (g_mag_start_date)
713: AND fnd_date.canonical_to_date (g_mag_end_date)
714: AND fnd_date.canonical_to_date (pai.action_information2) <=

Line 712: fnd_date.canonical_to_date (g_mag_start_date)

708: AND (fnd_date.canonical_to_date (pai.action_information2) BETWEEN
709: fnd_date.canonical_to_date (g_mag_start_date)
710: AND fnd_date.canonical_to_date (g_mag_end_date)
711: OR (pai.effective_date BETWEEN
712: fnd_date.canonical_to_date (g_mag_start_date)
713: AND fnd_date.canonical_to_date (g_mag_end_date)
714: AND fnd_date.canonical_to_date (pai.action_information2) <=
715: fnd_date.canonical_to_date (g_mag_end_date)))
716: AND fnd_date.canonical_to_date(pai.action_information2)

Line 713: AND fnd_date.canonical_to_date (g_mag_end_date)

709: fnd_date.canonical_to_date (g_mag_start_date)
710: AND fnd_date.canonical_to_date (g_mag_end_date)
711: OR (pai.effective_date BETWEEN
712: fnd_date.canonical_to_date (g_mag_start_date)
713: AND fnd_date.canonical_to_date (g_mag_end_date)
714: AND fnd_date.canonical_to_date (pai.action_information2) <=
715: fnd_date.canonical_to_date (g_mag_end_date)))
716: AND fnd_date.canonical_to_date(pai.action_information2)
717: BETWEEN paf.effective_start_date

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

710: AND fnd_date.canonical_to_date (g_mag_end_date)
711: OR (pai.effective_date BETWEEN
712: fnd_date.canonical_to_date (g_mag_start_date)
713: AND fnd_date.canonical_to_date (g_mag_end_date)
714: AND fnd_date.canonical_to_date (pai.action_information2) <=
715: fnd_date.canonical_to_date (g_mag_end_date)))
716: AND fnd_date.canonical_to_date(pai.action_information2)
717: BETWEEN paf.effective_start_date
718: AND paf.effective_end_date

Line 715: fnd_date.canonical_to_date (g_mag_end_date)))

711: OR (pai.effective_date BETWEEN
712: fnd_date.canonical_to_date (g_mag_start_date)
713: AND fnd_date.canonical_to_date (g_mag_end_date)
714: AND fnd_date.canonical_to_date (pai.action_information2) <=
715: fnd_date.canonical_to_date (g_mag_end_date)))
716: AND fnd_date.canonical_to_date(pai.action_information2)
717: BETWEEN paf.effective_start_date
718: AND paf.effective_end_date
719: AND paa_arch.assignment_action_id = lck.locked_action_id

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

712: fnd_date.canonical_to_date (g_mag_start_date)
713: AND fnd_date.canonical_to_date (g_mag_end_date)
714: AND fnd_date.canonical_to_date (pai.action_information2) <=
715: fnd_date.canonical_to_date (g_mag_end_date)))
716: AND fnd_date.canonical_to_date(pai.action_information2)
717: BETWEEN paf.effective_start_date
718: AND paf.effective_end_date
719: AND paa_arch.assignment_action_id = lck.locked_action_id
720: AND lck.locking_action_id = cp_assignment_action_id

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

720: AND lck.locking_action_id = cp_assignment_action_id
721: AND pai.action_context_type = 'AAP'
722: AND pai.action_information_category = 'MX SS TRANSACTIONS'
723:
724: ORDER BY fnd_date.canonical_to_date (pai.action_information2), -- tran dt
725: DECODE (pai.action_information4,
726: '08', 1,
727: '07', 2,
728: '02', 3),

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

735: CURSOR csr_tran_exists (cp_mag_asact_id number,
736: cp_person_id varchar2,
737: cp_tran_type varchar2,
738: cp_tran_dt date) IS
739: SELECT fnd_date.canonical_to_date(pai.action_information2) -- tran date
740: FROM pay_assignment_actions paa_mag,
741: pay_payroll_actions ppa_mag,
742: pay_assignment_actions paa_mag_prev,
743: pay_payroll_actions ppa_mag_prev,

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

755: AND paa_mag.assignment_action_id = cp_mag_asact_id
756: AND pai.action_information1 = cp_person_id -- person ID
757: AND pai.action_information4 = cp_tran_type -- transaction type
758: AND nvl(pai.action_information10, 'N') <> 'Y' -- do not report flag
759: AND ((fnd_date.canonical_to_date (pai.action_information2) >
760: cp_tran_dt) OR
761: (cp_tran_dt IS NULL))
762: AND pai.action_context_type = 'AAP'
763: AND pai.action_information_category = 'MX SS TRANSACTIONS'

Line 780: fnd_date.canonical_to_date(g_mag_end_date)

776:
777: CURSOR csr_asg_actions (cp_person_id number) IS
778: SELECT fnd_number.canonical_to_number(
779: pay_magtape_generic.get_parameter_value ('TRANSFER_ACT_ID')),
780: fnd_date.canonical_to_date(g_mag_end_date)
781: FROM DUAL
782: UNION
783: SELECT paa.assignment_action_id,
784: fnd_date.canonical_to_date(

Line 784: fnd_date.canonical_to_date(

780: fnd_date.canonical_to_date(g_mag_end_date)
781: FROM DUAL
782: UNION
783: SELECT paa.assignment_action_id,
784: fnd_date.canonical_to_date(
785: pay_mx_utility.get_legi_param_val('END_DATE',
786: ppa.legislative_parameters))
787: FROM pay_payroll_actions ppa,
788: pay_assignment_actions paa,

Line 793: AND fnd_date.canonical_to_date(

789: per_assignments_f paf
790: WHERE ppa.payroll_action_id = paa.payroll_action_id
791: AND paa.assignment_id = paf.assignment_id
792: AND paf.person_id = cp_person_id
793: AND fnd_date.canonical_to_date(
794: pay_mx_utility.get_legi_param_val('END_DATE',
795: ppa.legislative_parameters))
796: BETWEEN paf.effective_start_date AND paf.effective_end_date
797: AND ppa.action_type = 'X'

Line 805: AND cp_curr_date > fnd_date.canonical_to_date(

801: AND ppa.action_status = 'C'
802: /*AND cp_gre_id = fnd_number.canonical_to_number(
803: pay_mx_utility.get_legi_param_val('GRE',
804: ppa.legislative_parameters))
805: AND cp_curr_date > fnd_date.canonical_to_date(
806: pay_mx_utility.get_legi_param_val('END_DATE',
807: ppa.legislative_parameters))*/
808: AND fnd_number.canonical_to_number(g_mag_gre_id) =
809: fnd_number.canonical_to_number(

Line 812: AND fnd_date.canonical_to_date(g_mag_end_date) >

808: AND fnd_number.canonical_to_number(g_mag_gre_id) =
809: fnd_number.canonical_to_number(
810: pay_mx_utility.get_legi_param_val('GRE',
811: ppa.legislative_parameters))
812: AND fnd_date.canonical_to_date(g_mag_end_date) >
813: fnd_date.canonical_to_date(
814: pay_mx_utility.get_legi_param_val('END_DATE',
815: ppa.legislative_parameters))
816: ORDER BY 2 DESC;

Line 813: fnd_date.canonical_to_date(

809: fnd_number.canonical_to_number(
810: pay_mx_utility.get_legi_param_val('GRE',
811: ppa.legislative_parameters))
812: AND fnd_date.canonical_to_date(g_mag_end_date) >
813: fnd_date.canonical_to_date(
814: pay_mx_utility.get_legi_param_val('END_DATE',
815: ppa.legislative_parameters))
816: ORDER BY 2 DESC;
817:

Line 841: AND fnd_date.canonical_to_date(g_mag_end_date) >

837: AND fnd_number.canonical_to_number(g_mag_gre_id) =
838: fnd_number.canonical_to_number(
839: pay_mx_utility.get_legi_param_val('GRE',
840: ppa_sua.legislative_parameters))
841: AND fnd_date.canonical_to_date(g_mag_end_date) >
842: fnd_date.canonical_to_date(
843: pay_mx_utility.get_legi_param_val('END_DATE',
844: ppa_sua.legislative_parameters))
845: -- Bug 5998981

Line 842: fnd_date.canonical_to_date(

838: fnd_number.canonical_to_number(
839: pay_mx_utility.get_legi_param_val('GRE',
840: ppa_sua.legislative_parameters))
841: AND fnd_date.canonical_to_date(g_mag_end_date) >
842: fnd_date.canonical_to_date(
843: pay_mx_utility.get_legi_param_val('END_DATE',
844: ppa_sua.legislative_parameters))
845: -- Bug 5998981
846: AND DECODE (pai.action_information_category,

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

844: ppa_sua.legislative_parameters))
845: -- Bug 5998981
846: AND DECODE (pai.action_information_category,
847: 'MX SS TRANSACTIONS',
848: fnd_date.canonical_to_date(pai.action_information2),
849: hr_general.start_of_time)
850: BETWEEN fnd_date.canonical_to_date(
851: pay_mx_utility.get_legi_param_val('START_DATE',
852: ppa_sua.legislative_parameters))

Line 850: BETWEEN fnd_date.canonical_to_date(

846: AND DECODE (pai.action_information_category,
847: 'MX SS TRANSACTIONS',
848: fnd_date.canonical_to_date(pai.action_information2),
849: hr_general.start_of_time)
850: BETWEEN fnd_date.canonical_to_date(
851: pay_mx_utility.get_legi_param_val('START_DATE',
852: ppa_sua.legislative_parameters))
853: AND fnd_date.canonical_to_date(
854: pay_mx_utility.get_legi_param_val('END_DATE',

Line 853: AND fnd_date.canonical_to_date(

849: hr_general.start_of_time)
850: BETWEEN fnd_date.canonical_to_date(
851: pay_mx_utility.get_legi_param_val('START_DATE',
852: ppa_sua.legislative_parameters))
853: AND fnd_date.canonical_to_date(
854: pay_mx_utility.get_legi_param_val('END_DATE',
855: ppa_sua.legislative_parameters))
856: ORDER BY fnd_date.canonical_to_date (pai.action_information2) DESC;
857:

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

852: ppa_sua.legislative_parameters))
853: AND fnd_date.canonical_to_date(
854: pay_mx_utility.get_legi_param_val('END_DATE',
855: ppa_sua.legislative_parameters))
856: ORDER BY fnd_date.canonical_to_date (pai.action_information2) DESC;
857:
858: CURSOR c_get_imp_date (cp_gre_id NUMBER) IS
859: SELECT org_information6
860: FROM hr_organization_information

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

917: FETCH c_get_imp_date INTO ld_imp_date;
918: CLOSE c_get_imp_date;
919: hr_utility_trace ('ld_imp_date '|| ld_imp_date);
920:
921: SELECT fnd_date.date_to_canonical(MIN(creation_date))
922: INTO ld_event_strt_date
923: FROM pay_process_events ppe
924: WHERE EXISTS
925: (SELECT 1

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

927: WHERE table_name IN ('PER_ALL_PEOPLE_F','PER_ALL_ASSIGNMENTS_F','PAY_ELEMENT_ENTRIES_F','PAY_ELEMENT_ENTRY_VALUES_F')
928: AND ppe.event_update_id = peu.event_update_id
929: );
930:
931: IF fnd_date.canonical_to_date(ld_event_strt_date) >= fnd_date.canonical_to_date(NVL(ld_imp_date,ld_event_strt_date)) THEN
932: ld_imp_date := ld_event_strt_date;
933: END IF;
934:
935: hr_utility_trace ('ld_event_strt_date '|| ld_event_strt_date);

Line 1073: fnd_date.date_to_canonical(ld_tran_dt));

1069: FETCH csr_tran_exists INTO ld_tran_dt;
1070: CLOSE csr_tran_exists;
1071:
1072: hr_utility_trace('Above transaction was reported on '||
1073: fnd_date.date_to_canonical(ld_tran_dt));
1074:
1075: IF ld_tran_dt IS NOT NULL THEN
1076: ld_tran_dt := NULL;
1077: IF lv_tran_type = '08' THEN

Line 1094: fnd_date.date_to_canonical(ld_tran_dt));

1090: CLOSE csr_tran_exists;
1091:
1092: hr_utility_trace('Counter transaction of above '||
1093: 'transaction was reported on '||
1094: fnd_date.date_to_canonical(ld_tran_dt));
1095: IF ld_tran_dt IS NULL THEN
1096: hr_utility_trace('Suppressing above transaction');
1097: lv_show_curr_trans := 'N';
1098: END IF;

Line 1115: fnd_date.canonical_to_date(g_mag_end_date),

1111: CLOSE get_emp_trans;
1112: per_mx_ss_affiliation.process_transactions (
1113: lv_person_id,
1114: fnd_number.canonical_to_number(g_mag_gre_id),
1115: fnd_date.canonical_to_date(g_mag_end_date),
1116: 'SUA_MAG',
1117: 'SUA_MAG',
1118: 'RT',
1119: lt_tran);