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.PER_MX_SS_AFFILIATION dependencies on FND_DATE

Line 78: trunc on fnd_date.canonical_to_date to

74: sivanara 27-jun-2008 115.13 7185703 Added logic to filter the transaction
75: before implementation date
76: sivanara 16-jul-2008 115.14 7258802 In the procedure process_transaction
77: modified cursor csr_prev_idw by adding
78: trunc on fnd_date.canonical_to_date to
79: consider the first run of the GRE.
80: swamukhe 04-Oct-2008 115.18 6451017 Commented a set of code to so that the
81: rehire and termination.
82: vvijayku 07-Nov-2008 115.19 6451017 Modified the cursor get_emp_trans to get the

Line 179: SELECT fnd_date.date_to_canonical (effective_date + 1/(24 * 60 * 60))

175: (
176: P_TRANS_GRE number
177: ) RETURN VARCHAR2 AS
178: CURSOR csr_get_date_dispmag IS
179: SELECT fnd_date.date_to_canonical (effective_date + 1/(24 * 60 * 60))
180: FROM pay_payroll_actions
181: WHERE report_type = 'SS_AFFILIATION'
182: AND report_qualifier IN ('HIRES', 'SEPARATIONS', 'SALARY')
183: AND pay_mx_utility.get_legi_param_val('TRANS_GRE',

Line 190: SELECT fnd_date.date_to_canonical(

186: ORDER BY payroll_action_id DESC;
187:
188:
189: CURSOR csr_get_date_affl IS
190: SELECT fnd_date.date_to_canonical(
191: fnd_date.canonical_to_date(
192: pay_mx_utility.get_legi_param_val('END_DATE',
193: legislative_parameters)) +
194: 1/(24 * 60 * 60))

Line 191: fnd_date.canonical_to_date(

187:
188:
189: CURSOR csr_get_date_affl IS
190: SELECT fnd_date.date_to_canonical(
191: fnd_date.canonical_to_date(
192: pay_mx_utility.get_legi_param_val('END_DATE',
193: legislative_parameters)) +
194: 1/(24 * 60 * 60))
195: FROM pay_payroll_actions

Line 388: ld_end_date := fnd_date.canonical_to_date (g_end_date)+1;

384: /*Bug 8768679 - Added the following code to increase the g_end_date by 1
385: so that it cane be used in the range cursor and it will pick the future
386: hired employee*/
387:
388: ld_end_date := fnd_date.canonical_to_date (g_end_date)+1;
389: l_new_end_date := fnd_date.date_to_canonical (ld_end_date);
390: hr_utility_trace ('End date is '|| l_new_end_date);
391:
392:

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

385: so that it cane be used in the range cursor and it will pick the future
386: hired employee*/
387:
388: ld_end_date := fnd_date.canonical_to_date (g_end_date)+1;
389: l_new_end_date := fnd_date.date_to_canonical (ld_end_date);
390: hr_utility_trace ('End date is '|| l_new_end_date);
391:
392:
393: -- Bug 6008833

Line 398: /*AND fnd_date.canonical_to_date('''||l_new_end_date

394: p_sqlstr :=
395: 'SELECT DISTINCT person_id
396: FROM per_assignments_f
397: WHERE business_group_id = '||g_business_group||'
398: /*AND fnd_date.canonical_to_date('''||l_new_end_date
399: ||''') BETWEEN effective_start_date AND effective_end_date*/
400: AND per_mx_ss_affiliation.derive_gre_from_loc_scl (location_id,
401: business_group_id,
402: soft_coding_keyflex_id,

Line 403: fnd_date.canonical_to_date('''||

399: ||''') BETWEEN effective_start_date AND effective_end_date*/
400: AND per_mx_ss_affiliation.derive_gre_from_loc_scl (location_id,
401: business_group_id,
402: soft_coding_keyflex_id,
403: fnd_date.canonical_to_date('''||
404: l_new_end_date||''')) IN
405: (SELECT organization_id
406: FROM hr_organization_information
407: WHERE org_information_context = ''MX_SOC_SEC_DETAILS''

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

445: AND pai.action_information4 IN ('02', '07', '08')
446: AND NVL(pai.action_information10, 'N') <> 'Y'
447: -- Bug 6060070
448: AND (DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
449: fnd_date.canonical_to_date (pai.action_information2),
450: hr_general.start_of_time) BETWEEN
451: fnd_date.canonical_to_date (g_start_date)
452: /*Bug 8768679*/
453: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_end_date))

Line 451: fnd_date.canonical_to_date (g_start_date)

447: -- Bug 6060070
448: AND (DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
449: fnd_date.canonical_to_date (pai.action_information2),
450: hr_general.start_of_time) BETWEEN
451: fnd_date.canonical_to_date (g_start_date)
452: /*Bug 8768679*/
453: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_end_date))
454: OR (pai.effective_date BETWEEN
455: fnd_date.canonical_to_date (g_start_date)

Line 453: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_end_date))

449: fnd_date.canonical_to_date (pai.action_information2),
450: hr_general.start_of_time) BETWEEN
451: fnd_date.canonical_to_date (g_start_date)
452: /*Bug 8768679*/
453: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_end_date))
454: OR (pai.effective_date BETWEEN
455: fnd_date.canonical_to_date (g_start_date)
456: /*Bug 8768679*/
457: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_end_date))

Line 455: fnd_date.canonical_to_date (g_start_date)

451: fnd_date.canonical_to_date (g_start_date)
452: /*Bug 8768679*/
453: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_end_date))
454: OR (pai.effective_date BETWEEN
455: fnd_date.canonical_to_date (g_start_date)
456: /*Bug 8768679*/
457: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_end_date))
458: /*NOT EXISTS (SELECT 'X'
459: FROM pay_payroll_actions ppa_affl,

Line 457: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_end_date))

453: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_end_date))
454: OR (pai.effective_date BETWEEN
455: fnd_date.canonical_to_date (g_start_date)
456: /*Bug 8768679*/
457: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_end_date))
458: /*NOT EXISTS (SELECT 'X'
459: FROM pay_payroll_actions ppa_affl,
460: pay_assignment_actions paa_affl,
461: pay_action_interlocks lck

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

468: AND ppa_affl.action_status = 'C')*/
469: -- Bug 6060070
470: /*Bug 8768679*/
471: AND DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
472: fnd_date.canonical_to_date (pai.action_information2),
473: hr_general.start_of_time) <=
474: fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_end_date))
475: )
476: )

Line 474: fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_end_date))

470: /*Bug 8768679*/
471: AND DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
472: fnd_date.canonical_to_date (pai.action_information2),
473: hr_general.start_of_time) <=
474: fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_end_date))
475: )
476: )
477: /*AND fnd_date.canonical_to_date (g_end_date) BETWEEN
478: paf.effective_start_date

Line 477: /*AND fnd_date.canonical_to_date (g_end_date) BETWEEN

473: hr_general.start_of_time) <=
474: fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_end_date))
475: )
476: )
477: /*AND fnd_date.canonical_to_date (g_end_date) BETWEEN
478: paf.effective_start_date
479: AND paf.effective_end_date*/
480: ORDER BY paf.person_id,
481: pai.action_context_id,

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

501: AND pai.action_information4 IN ('02', '07', '08')
502: AND NVL(pai.action_information10, 'N') <> 'Y'
503: -- Bug 6060070
504: AND (DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
505: fnd_date.canonical_to_date (pai.action_information2),
506: hr_general.start_of_time) BETWEEN
507: fnd_date.canonical_to_date (g_start_date)
508: /*Bug 8768679*/
509: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_end_date))

Line 507: fnd_date.canonical_to_date (g_start_date)

503: -- Bug 6060070
504: AND (DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
505: fnd_date.canonical_to_date (pai.action_information2),
506: hr_general.start_of_time) BETWEEN
507: fnd_date.canonical_to_date (g_start_date)
508: /*Bug 8768679*/
509: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_end_date))
510: OR (pai.effective_date BETWEEN
511: trunc(fnd_date.canonical_to_date (g_start_date))

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

505: fnd_date.canonical_to_date (pai.action_information2),
506: hr_general.start_of_time) BETWEEN
507: fnd_date.canonical_to_date (g_start_date)
508: /*Bug 8768679*/
509: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_end_date))
510: OR (pai.effective_date BETWEEN
511: trunc(fnd_date.canonical_to_date (g_start_date))
512: /*Bug 8768679*/
513: AND trunc(fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_end_date)))

Line 511: trunc(fnd_date.canonical_to_date (g_start_date))

507: fnd_date.canonical_to_date (g_start_date)
508: /*Bug 8768679*/
509: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_end_date))
510: OR (pai.effective_date BETWEEN
511: trunc(fnd_date.canonical_to_date (g_start_date))
512: /*Bug 8768679*/
513: AND trunc(fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_end_date)))
514: /*NOT EXISTS (SELECT 'X'
515: FROM pay_payroll_actions ppa_affl,

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

509: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_end_date))
510: OR (pai.effective_date BETWEEN
511: trunc(fnd_date.canonical_to_date (g_start_date))
512: /*Bug 8768679*/
513: AND trunc(fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_end_date)))
514: /*NOT EXISTS (SELECT 'X'
515: FROM pay_payroll_actions ppa_affl,
516: pay_assignment_actions paa_affl,
517: pay_action_interlocks lck

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

524: AND ppa_affl.action_status = 'C')*/
525: -- Bug 6060070
526: /*Bug 8768679*/
527: AND DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
528: fnd_date.canonical_to_date (pai.action_information2),
529: hr_general.start_of_time) <=
530: fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_end_date))
531: )
532: )

Line 530: fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_end_date))

526: /*Bug 8768679*/
527: AND DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
528: fnd_date.canonical_to_date (pai.action_information2),
529: hr_general.start_of_time) <=
530: fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_end_date))
531: )
532: )
533: /*AND fnd_date.canonical_to_date (g_end_date) BETWEEN
534: paf.effective_start_date

Line 533: /*AND fnd_date.canonical_to_date (g_end_date) BETWEEN

529: hr_general.start_of_time) <=
530: fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_end_date))
531: )
532: )
533: /*AND fnd_date.canonical_to_date (g_end_date) BETWEEN
534: paf.effective_start_date
535: AND paf.effective_end_date*/
536: ORDER BY paf.person_id,
537: pai.action_context_id,

Line 600: ld_end_date := fnd_date.canonical_to_date (g_end_date)+1;

596:
597: /*Bug 8768679 - Added the following code to increase the g_end_date by 1
598: so that it cane be used in the action creation cursors */
599:
600: ld_end_date := fnd_date.canonical_to_date (g_end_date)+1;
601: l_new_end_date := fnd_date.date_to_canonical (ld_end_date);
602: hr_utility_trace ('End date is '|| l_new_end_date);
603:
604: ln_prev_person_id := -1;

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

597: /*Bug 8768679 - Added the following code to increase the g_end_date by 1
598: so that it cane be used in the action creation cursors */
599:
600: ld_end_date := fnd_date.canonical_to_date (g_end_date)+1;
601: l_new_end_date := fnd_date.date_to_canonical (ld_end_date);
602: hr_utility_trace ('End date is '|| l_new_end_date);
603:
604: ln_prev_person_id := -1;
605: ln_prev_arch_asg_act := -1;

Line 799: AND p_end_date > fnd_date.canonical_to_date(

795: AND ppa_mag.action_status = 'C'
796: AND p_gre_id = fnd_number.canonical_to_number(
797: pay_mx_utility.get_legi_param_val(cp_gre_token,
798: ppa_mag.legislative_parameters))
799: AND p_end_date > fnd_date.canonical_to_date(
800: pay_mx_utility.get_legi_param_val('END_DATE',
801: ppa_mag.legislative_parameters))
802: -- Bug 5998981
803: /*Bug 8768679 - A decode statement has been added so that previous idw value can be obtained

Line 808: TRUNC(fnd_date.canonical_to_date(pai.action_information2)),

804: when the transaction date of the immediate earlier 08 transaction lies between START_DATE and
805: END_DATE+1*/
806: AND DECODE (pai.action_information_category,
807: 'MX SS TRANSACTIONS',
808: TRUNC(fnd_date.canonical_to_date(pai.action_information2)),
809: hr_general.start_of_time)
810: BETWEEN TRUNC(fnd_date.canonical_to_date(
811: pay_mx_utility.get_legi_param_val('START_DATE',
812: ppa_mag.legislative_parameters)))

Line 810: BETWEEN TRUNC(fnd_date.canonical_to_date(

806: AND DECODE (pai.action_information_category,
807: 'MX SS TRANSACTIONS',
808: TRUNC(fnd_date.canonical_to_date(pai.action_information2)),
809: hr_general.start_of_time)
810: BETWEEN TRUNC(fnd_date.canonical_to_date(
811: pay_mx_utility.get_legi_param_val('START_DATE',
812: ppa_mag.legislative_parameters)))
813: AND DECODE (pai.action_information4,'08',
814: (TRUNC (fnd_date.canonical_to_date(

Line 814: (TRUNC (fnd_date.canonical_to_date(

810: BETWEEN TRUNC(fnd_date.canonical_to_date(
811: pay_mx_utility.get_legi_param_val('START_DATE',
812: ppa_mag.legislative_parameters)))
813: AND DECODE (pai.action_information4,'08',
814: (TRUNC (fnd_date.canonical_to_date(
815: pay_mx_utility.get_legi_param_val('END_DATE',
816: ppa_mag.legislative_parameters)))+1),
817: (TRUNC (fnd_date.canonical_to_date(
818: pay_mx_utility.get_legi_param_val('END_DATE',

Line 817: (TRUNC (fnd_date.canonical_to_date(

813: AND DECODE (pai.action_information4,'08',
814: (TRUNC (fnd_date.canonical_to_date(
815: pay_mx_utility.get_legi_param_val('END_DATE',
816: ppa_mag.legislative_parameters)))+1),
817: (TRUNC (fnd_date.canonical_to_date(
818: pay_mx_utility.get_legi_param_val('END_DATE',
819: ppa_mag.legislative_parameters)))))
820: ORDER BY fnd_date.canonical_to_date (pai.action_information2) DESC;
821:

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

816: ppa_mag.legislative_parameters)))+1),
817: (TRUNC (fnd_date.canonical_to_date(
818: pay_mx_utility.get_legi_param_val('END_DATE',
819: ppa_mag.legislative_parameters)))))
820: ORDER BY fnd_date.canonical_to_date (pai.action_information2) DESC;
821:
822: l_proc_name VARCHAR2(100);
823: lv_gre_token VARCHAR2(20);
824: ln_cntr NUMBER;

Line 992: AND pai.effective_date <= fnd_date.canonical_to_date (g_end_date)

988: AND lck.locked_action_id = pai.action_context_id*/
989: AND pai.action_context_type = 'AAP'
990: AND pai.action_information1 = fnd_number.number_to_canonical(cp_person_id)
991: AND nvl(pai.action_information21, 'N') <> 'Y' -- Do not report flag
992: AND pai.effective_date <= fnd_date.canonical_to_date (g_end_date)
993: ORDER BY pai.effective_date DESC/*,
994: decode (paf.primary_flag, 'Y', 1, 2),
995: paf.assignment_id*/;
996:

Line 1000: fnd_date.canonical_to_date (g_end_date)

996:
997: CURSOR csr_asg_actions (cp_person_id number) IS
998: /*SELECT fnd_number.canonical_to_number(
999: pay_magtape_generic.get_parameter_value ('TRANSFER_ACT_ID')),
1000: fnd_date.canonical_to_date (g_end_date)
1001: FROM dual
1002: UNION
1003: SELECT paa.assignment_action_id,
1004: fnd_date.canonical_to_date(

Line 1004: fnd_date.canonical_to_date(

1000: fnd_date.canonical_to_date (g_end_date)
1001: FROM dual
1002: UNION
1003: SELECT paa.assignment_action_id,
1004: fnd_date.canonical_to_date(
1005: pay_mx_utility.get_legi_param_val('END_DATE',
1006: ppa.legislative_parameters))
1007: FROM pay_payroll_actions ppa,
1008: pay_assignment_actions paa,

Line 1023: AND fnd_date.canonical_to_date(

1019: AND ppa.action_status = 'C'
1020: AND pay_mx_utility.get_legi_param_val('TRANS_GRE',
1021: ppa.legislative_parameters) =
1022: g_trans_gre_id
1023: AND fnd_date.canonical_to_date(
1024: pay_mx_utility.get_legi_param_val('END_DATE',
1025: ppa.legislative_parameters)) <
1026: fnd_date.canonical_to_date (g_end_date)
1027: ORDER BY 2 DESC;*/

Line 1026: fnd_date.canonical_to_date (g_end_date)

1022: g_trans_gre_id
1023: AND fnd_date.canonical_to_date(
1024: pay_mx_utility.get_legi_param_val('END_DATE',
1025: ppa.legislative_parameters)) <
1026: fnd_date.canonical_to_date (g_end_date)
1027: ORDER BY 2 DESC;*/
1028:
1029:
1030: SELECT pai.action_context_id,

Line 1036: AND pai.effective_date <= fnd_date.canonical_to_date (g_end_date)

1032: FROM pay_action_information pai
1033: WHERE pai.action_information_category = 'MX SS PERSON INFORMATION'
1034: AND pai.action_information1 = fnd_number.number_to_canonical(cp_person_id)
1035: -- Bug 6060070
1036: AND pai.effective_date <= fnd_date.canonical_to_date (g_end_date)
1037: /*AND (DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
1038: fnd_date.canonical_to_date (pai.action_information2),
1039: hr_general.start_of_time) BETWEEN
1040: fnd_date.canonical_to_date (g_start_date)

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

1034: AND pai.action_information1 = fnd_number.number_to_canonical(cp_person_id)
1035: -- Bug 6060070
1036: AND pai.effective_date <= fnd_date.canonical_to_date (g_end_date)
1037: /*AND (DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
1038: fnd_date.canonical_to_date (pai.action_information2),
1039: hr_general.start_of_time) BETWEEN
1040: fnd_date.canonical_to_date (g_start_date)
1041: AND fnd_date.canonical_to_date (g_end_date)
1042: OR (pai.effective_date BETWEEN

Line 1040: fnd_date.canonical_to_date (g_start_date)

1036: AND pai.effective_date <= fnd_date.canonical_to_date (g_end_date)
1037: /*AND (DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
1038: fnd_date.canonical_to_date (pai.action_information2),
1039: hr_general.start_of_time) BETWEEN
1040: fnd_date.canonical_to_date (g_start_date)
1041: AND fnd_date.canonical_to_date (g_end_date)
1042: OR (pai.effective_date BETWEEN
1043: fnd_date.canonical_to_date (g_start_date)
1044: AND fnd_date.canonical_to_date (g_end_date)

Line 1041: AND fnd_date.canonical_to_date (g_end_date)

1037: /*AND (DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
1038: fnd_date.canonical_to_date (pai.action_information2),
1039: hr_general.start_of_time) BETWEEN
1040: fnd_date.canonical_to_date (g_start_date)
1041: AND fnd_date.canonical_to_date (g_end_date)
1042: OR (pai.effective_date BETWEEN
1043: fnd_date.canonical_to_date (g_start_date)
1044: AND fnd_date.canonical_to_date (g_end_date)
1045: -- Bug 6060070

Line 1043: fnd_date.canonical_to_date (g_start_date)

1039: hr_general.start_of_time) BETWEEN
1040: fnd_date.canonical_to_date (g_start_date)
1041: AND fnd_date.canonical_to_date (g_end_date)
1042: OR (pai.effective_date BETWEEN
1043: fnd_date.canonical_to_date (g_start_date)
1044: AND fnd_date.canonical_to_date (g_end_date)
1045: -- Bug 6060070
1046: AND DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
1047: fnd_date.canonical_to_date (pai.action_information2),

Line 1044: AND fnd_date.canonical_to_date (g_end_date)

1040: fnd_date.canonical_to_date (g_start_date)
1041: AND fnd_date.canonical_to_date (g_end_date)
1042: OR (pai.effective_date BETWEEN
1043: fnd_date.canonical_to_date (g_start_date)
1044: AND fnd_date.canonical_to_date (g_end_date)
1045: -- Bug 6060070
1046: AND DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
1047: fnd_date.canonical_to_date (pai.action_information2),
1048: hr_general.start_of_time) <=

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

1043: fnd_date.canonical_to_date (g_start_date)
1044: AND fnd_date.canonical_to_date (g_end_date)
1045: -- Bug 6060070
1046: AND DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
1047: fnd_date.canonical_to_date (pai.action_information2),
1048: hr_general.start_of_time) <=
1049: fnd_date.canonical_to_date (g_end_date)
1050: )
1051: )

Line 1049: fnd_date.canonical_to_date (g_end_date)

1045: -- Bug 6060070
1046: AND DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
1047: fnd_date.canonical_to_date (pai.action_information2),
1048: hr_general.start_of_time) <=
1049: fnd_date.canonical_to_date (g_end_date)
1050: )
1051: )
1052: /*AND fnd_date.canonical_to_date (g_end_date) BETWEEN
1053: paf.effective_start_date

Line 1052: /*AND fnd_date.canonical_to_date (g_end_date) BETWEEN

1048: hr_general.start_of_time) <=
1049: fnd_date.canonical_to_date (g_end_date)
1050: )
1051: )
1052: /*AND fnd_date.canonical_to_date (g_end_date) BETWEEN
1053: paf.effective_start_date
1054: AND paf.effective_end_date*/
1055: ORDER BY pai.effective_date DESC;
1056:

Line 1087: fnd_date.canonical_to_date (pai.action_information2),hr_general.start_of_time

1083: AND pai.action_information4 IN ('02', '07', '08')
1084: AND NVL(pai.action_information10, 'N') <> 'Y'
1085: --Bug 7185703
1086: AND DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
1087: fnd_date.canonical_to_date (pai.action_information2),hr_general.start_of_time
1088: ) >= fnd_date.canonical_to_date(cp_imp_date)
1089: -- Bug 6060070
1090: AND (DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
1091: fnd_date.canonical_to_date (pai.action_information2),

Line 1088: ) >= fnd_date.canonical_to_date(cp_imp_date)

1084: AND NVL(pai.action_information10, 'N') <> 'Y'
1085: --Bug 7185703
1086: AND DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
1087: fnd_date.canonical_to_date (pai.action_information2),hr_general.start_of_time
1088: ) >= fnd_date.canonical_to_date(cp_imp_date)
1089: -- Bug 6060070
1090: AND (DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
1091: fnd_date.canonical_to_date (pai.action_information2),
1092: hr_general.start_of_time) BETWEEN

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

1087: fnd_date.canonical_to_date (pai.action_information2),hr_general.start_of_time
1088: ) >= fnd_date.canonical_to_date(cp_imp_date)
1089: -- Bug 6060070
1090: AND (DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
1091: fnd_date.canonical_to_date (pai.action_information2),
1092: hr_general.start_of_time) BETWEEN
1093: fnd_date.canonical_to_date (g_start_date)
1094: /*Bug 8768679*/
1095: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_end_date))

Line 1093: fnd_date.canonical_to_date (g_start_date)

1089: -- Bug 6060070
1090: AND (DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
1091: fnd_date.canonical_to_date (pai.action_information2),
1092: hr_general.start_of_time) BETWEEN
1093: fnd_date.canonical_to_date (g_start_date)
1094: /*Bug 8768679*/
1095: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_end_date))
1096: OR (pai.effective_date BETWEEN
1097: fnd_date.canonical_to_date (g_start_date)

Line 1095: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_end_date))

1091: fnd_date.canonical_to_date (pai.action_information2),
1092: hr_general.start_of_time) BETWEEN
1093: fnd_date.canonical_to_date (g_start_date)
1094: /*Bug 8768679*/
1095: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_end_date))
1096: OR (pai.effective_date BETWEEN
1097: fnd_date.canonical_to_date (g_start_date)
1098: /*Bug 8768679*/
1099: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_end_date))

Line 1097: fnd_date.canonical_to_date (g_start_date)

1093: fnd_date.canonical_to_date (g_start_date)
1094: /*Bug 8768679*/
1095: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_end_date))
1096: OR (pai.effective_date BETWEEN
1097: fnd_date.canonical_to_date (g_start_date)
1098: /*Bug 8768679*/
1099: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_end_date))
1100: /*NOT EXISTS (SELECT 'X'
1101: FROM pay_payroll_actions ppa_affl,

Line 1099: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_end_date))

1095: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_end_date))
1096: OR (pai.effective_date BETWEEN
1097: fnd_date.canonical_to_date (g_start_date)
1098: /*Bug 8768679*/
1099: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_end_date))
1100: /*NOT EXISTS (SELECT 'X'
1101: FROM pay_payroll_actions ppa_affl,
1102: pay_assignment_actions paa_affl,
1103: pay_action_interlocks lck

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

1110: AND ppa_affl.action_status = 'C')*/
1111: -- Bug 6060070
1112: /*Bug 8768679*/
1113: AND DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
1114: fnd_date.canonical_to_date (pai.action_information2),
1115: hr_general.start_of_time) <=
1116: fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_end_date))
1117: )
1118: )

Line 1116: fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_end_date))

1112: /*Bug 8768679*/
1113: AND DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
1114: fnd_date.canonical_to_date (pai.action_information2),
1115: hr_general.start_of_time) <=
1116: fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_end_date))
1117: )
1118: )
1119: ORDER BY fnd_date.canonical_to_date (pai.action_information2),
1120: DECODE (pai.action_information4,

Line 1119: ORDER BY fnd_date.canonical_to_date (pai.action_information2),

1115: hr_general.start_of_time) <=
1116: fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_end_date))
1117: )
1118: )
1119: ORDER BY fnd_date.canonical_to_date (pai.action_information2),
1120: DECODE (pai.action_information4,
1121: '08', 1,
1122: '07', 2,
1123: '02', 3);

Line 1180: ld_end_date := fnd_date.canonical_to_date (g_end_date)+1;

1176:
1177: /*Bug 8768679 - Added the following code to increase the g_end_date by 1
1178: so that it cane be used in the csr_transactions cursor */
1179:
1180: ld_end_date := fnd_date.canonical_to_date (g_end_date)+1;
1181: l_new_end_date := fnd_date.date_to_canonical (ld_end_date);
1182: hr_utility_trace ('End date is '|| l_new_end_date);
1183:
1184: ln_legal_er := hr_mx_utility.get_legal_employer(g_business_group,

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

1177: /*Bug 8768679 - Added the following code to increase the g_end_date by 1
1178: so that it cane be used in the csr_transactions cursor */
1179:
1180: ld_end_date := fnd_date.canonical_to_date (g_end_date)+1;
1181: l_new_end_date := fnd_date.date_to_canonical (ld_end_date);
1182: hr_utility_trace ('End date is '|| l_new_end_date);
1183:
1184: ln_legal_er := hr_mx_utility.get_legal_employer(g_business_group,
1185: g_trans_gre_id);

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

1189: FETCH c_get_imp_date INTO ld_imp_date;
1190: CLOSE c_get_imp_date;
1191: hr_utility_trace ('ld_imp_date '|| ld_imp_date);
1192:
1193: SELECT fnd_date.date_to_canonical(MIN(creation_date))
1194: INTO ld_event_strt_date
1195: FROM pay_process_events ppe
1196: WHERE EXISTS
1197: (SELECT 1

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

1199: WHERE table_name IN ('PER_ALL_PEOPLE_F','PER_ALL_ASSIGNMENTS_F','PAY_ELEMENT_ENTRIES_F','PAY_ELEMENT_ENTRY_VALUES_F')
1200: AND ppe.event_update_id = peu.event_update_id
1201: );
1202:
1203: IF fnd_date.canonical_to_date(ld_event_strt_date) >= fnd_date.canonical_to_date(NVL(ld_imp_date,ld_event_strt_date)) THEN
1204: ld_imp_date := ld_event_strt_date;
1205: END IF;
1206:
1207: hr_utility_trace ('ld_event_strt_date '|| ld_event_strt_date);

Line 1298: fnd_date.canonical_to_date(g_end_date),

1294: END LOOP;
1295: CLOSE csr_transactions;
1296: process_transactions (lv_person_id,
1297: fnd_number.canonical_to_number(g_trans_gre_id),
1298: fnd_date.canonical_to_date(g_end_date),
1299: 'MX_SS_AFFL',
1300: 'MX_SS_AFFL',
1301: 'RT',
1302: lt_tran);