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: ***************************************************************************/
81:
82: --

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

156: (
157: P_TRANS_GRE number
158: ) RETURN VARCHAR2 AS
159: CURSOR csr_get_date_dispmag IS
160: SELECT fnd_date.date_to_canonical (effective_date + 1/(24 * 60 * 60))
161: FROM pay_payroll_actions
162: WHERE report_type = 'SS_AFFILIATION'
163: AND report_qualifier IN ('HIRES', 'SEPARATIONS', 'SALARY')
164: AND pay_mx_utility.get_legi_param_val('TRANS_GRE',

Line 171: SELECT fnd_date.date_to_canonical(

167: ORDER BY payroll_action_id DESC;
168:
169:
170: CURSOR csr_get_date_affl IS
171: SELECT fnd_date.date_to_canonical(
172: fnd_date.canonical_to_date(
173: pay_mx_utility.get_legi_param_val('END_DATE',
174: legislative_parameters)) +
175: 1/(24 * 60 * 60))

Line 172: fnd_date.canonical_to_date(

168:
169:
170: CURSOR csr_get_date_affl IS
171: SELECT fnd_date.date_to_canonical(
172: fnd_date.canonical_to_date(
173: pay_mx_utility.get_legi_param_val('END_DATE',
174: legislative_parameters)) +
175: 1/(24 * 60 * 60))
176: FROM pay_payroll_actions

Line 369: /*AND fnd_date.canonical_to_date('''||g_end_date

365: p_sqlstr :=
366: 'SELECT DISTINCT person_id
367: FROM per_assignments_f
368: WHERE business_group_id = '||g_business_group||'
369: /*AND fnd_date.canonical_to_date('''||g_end_date
370: ||''') BETWEEN effective_start_date AND effective_end_date*/
371: AND per_mx_ss_affiliation.derive_gre_from_loc_scl (location_id,
372: business_group_id,
373: soft_coding_keyflex_id,

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

370: ||''') BETWEEN effective_start_date AND effective_end_date*/
371: AND per_mx_ss_affiliation.derive_gre_from_loc_scl (location_id,
372: business_group_id,
373: soft_coding_keyflex_id,
374: fnd_date.canonical_to_date('''||
375: g_end_date||''')) IN
376: (SELECT organization_id
377: FROM hr_organization_information
378: WHERE org_information_context = ''MX_SOC_SEC_DETAILS''

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

414: AND pai.action_information4 IN ('02', '07', '08')
415: AND NVL(pai.action_information10, 'N') <> 'Y'
416: -- Bug 6060070
417: AND (DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
418: fnd_date.canonical_to_date (pai.action_information2),
419: hr_general.start_of_time) BETWEEN
420: fnd_date.canonical_to_date (g_start_date)
421: AND fnd_date.canonical_to_date (g_end_date)
422: OR (pai.effective_date BETWEEN

Line 420: fnd_date.canonical_to_date (g_start_date)

416: -- Bug 6060070
417: AND (DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
418: fnd_date.canonical_to_date (pai.action_information2),
419: hr_general.start_of_time) BETWEEN
420: fnd_date.canonical_to_date (g_start_date)
421: AND fnd_date.canonical_to_date (g_end_date)
422: OR (pai.effective_date BETWEEN
423: fnd_date.canonical_to_date (g_start_date)
424: AND fnd_date.canonical_to_date (g_end_date)

Line 421: AND fnd_date.canonical_to_date (g_end_date)

417: AND (DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
418: fnd_date.canonical_to_date (pai.action_information2),
419: hr_general.start_of_time) BETWEEN
420: fnd_date.canonical_to_date (g_start_date)
421: AND fnd_date.canonical_to_date (g_end_date)
422: OR (pai.effective_date BETWEEN
423: fnd_date.canonical_to_date (g_start_date)
424: AND fnd_date.canonical_to_date (g_end_date)
425: /*NOT EXISTS (SELECT 'X'

Line 423: fnd_date.canonical_to_date (g_start_date)

419: hr_general.start_of_time) BETWEEN
420: fnd_date.canonical_to_date (g_start_date)
421: AND fnd_date.canonical_to_date (g_end_date)
422: OR (pai.effective_date BETWEEN
423: fnd_date.canonical_to_date (g_start_date)
424: AND fnd_date.canonical_to_date (g_end_date)
425: /*NOT EXISTS (SELECT 'X'
426: FROM pay_payroll_actions ppa_affl,
427: pay_assignment_actions paa_affl,

Line 424: AND fnd_date.canonical_to_date (g_end_date)

420: fnd_date.canonical_to_date (g_start_date)
421: AND fnd_date.canonical_to_date (g_end_date)
422: OR (pai.effective_date BETWEEN
423: fnd_date.canonical_to_date (g_start_date)
424: AND fnd_date.canonical_to_date (g_end_date)
425: /*NOT EXISTS (SELECT 'X'
426: FROM pay_payroll_actions ppa_affl,
427: pay_assignment_actions paa_affl,
428: pay_action_interlocks lck

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

434: AND ppa_affl.report_category = 'RT'
435: AND ppa_affl.action_status = 'C')*/
436: -- Bug 6060070
437: AND DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
438: fnd_date.canonical_to_date (pai.action_information2),
439: hr_general.start_of_time) <=
440: fnd_date.canonical_to_date (g_end_date)
441: )
442: )

Line 440: fnd_date.canonical_to_date (g_end_date)

436: -- Bug 6060070
437: AND DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
438: fnd_date.canonical_to_date (pai.action_information2),
439: hr_general.start_of_time) <=
440: fnd_date.canonical_to_date (g_end_date)
441: )
442: )
443: /*AND fnd_date.canonical_to_date (g_end_date) BETWEEN
444: paf.effective_start_date

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

439: hr_general.start_of_time) <=
440: fnd_date.canonical_to_date (g_end_date)
441: )
442: )
443: /*AND fnd_date.canonical_to_date (g_end_date) BETWEEN
444: paf.effective_start_date
445: AND paf.effective_end_date*/
446: ORDER BY paf.person_id,
447: pai.action_context_id,

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

466: AND pai.action_information4 IN ('02', '07', '08')
467: AND NVL(pai.action_information10, 'N') <> 'Y'
468: -- Bug 6060070
469: AND (DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
470: fnd_date.canonical_to_date (pai.action_information2),
471: hr_general.start_of_time) BETWEEN
472: fnd_date.canonical_to_date (g_start_date)
473: AND fnd_date.canonical_to_date (g_end_date)
474: OR (pai.effective_date BETWEEN

Line 472: fnd_date.canonical_to_date (g_start_date)

468: -- Bug 6060070
469: AND (DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
470: fnd_date.canonical_to_date (pai.action_information2),
471: hr_general.start_of_time) BETWEEN
472: fnd_date.canonical_to_date (g_start_date)
473: AND fnd_date.canonical_to_date (g_end_date)
474: OR (pai.effective_date BETWEEN
475: fnd_date.canonical_to_date (g_start_date)
476: AND fnd_date.canonical_to_date (g_end_date)

Line 473: AND fnd_date.canonical_to_date (g_end_date)

469: AND (DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
470: fnd_date.canonical_to_date (pai.action_information2),
471: hr_general.start_of_time) BETWEEN
472: fnd_date.canonical_to_date (g_start_date)
473: AND fnd_date.canonical_to_date (g_end_date)
474: OR (pai.effective_date BETWEEN
475: fnd_date.canonical_to_date (g_start_date)
476: AND fnd_date.canonical_to_date (g_end_date)
477: /*NOT EXISTS (SELECT 'X'

Line 475: fnd_date.canonical_to_date (g_start_date)

471: hr_general.start_of_time) BETWEEN
472: fnd_date.canonical_to_date (g_start_date)
473: AND fnd_date.canonical_to_date (g_end_date)
474: OR (pai.effective_date BETWEEN
475: fnd_date.canonical_to_date (g_start_date)
476: AND fnd_date.canonical_to_date (g_end_date)
477: /*NOT EXISTS (SELECT 'X'
478: FROM pay_payroll_actions ppa_affl,
479: pay_assignment_actions paa_affl,

Line 476: AND fnd_date.canonical_to_date (g_end_date)

472: fnd_date.canonical_to_date (g_start_date)
473: AND fnd_date.canonical_to_date (g_end_date)
474: OR (pai.effective_date BETWEEN
475: fnd_date.canonical_to_date (g_start_date)
476: AND fnd_date.canonical_to_date (g_end_date)
477: /*NOT EXISTS (SELECT 'X'
478: FROM pay_payroll_actions ppa_affl,
479: pay_assignment_actions paa_affl,
480: pay_action_interlocks lck

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

486: AND ppa_affl.report_category = 'RT'
487: AND ppa_affl.action_status = 'C')*/
488: -- Bug 6060070
489: AND DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
490: fnd_date.canonical_to_date (pai.action_information2),
491: hr_general.start_of_time) <=
492: fnd_date.canonical_to_date (g_end_date)
493: )
494: )

Line 492: fnd_date.canonical_to_date (g_end_date)

488: -- Bug 6060070
489: AND DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
490: fnd_date.canonical_to_date (pai.action_information2),
491: hr_general.start_of_time) <=
492: fnd_date.canonical_to_date (g_end_date)
493: )
494: )
495: /*AND fnd_date.canonical_to_date (g_end_date) BETWEEN
496: paf.effective_start_date

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

491: hr_general.start_of_time) <=
492: fnd_date.canonical_to_date (g_end_date)
493: )
494: )
495: /*AND fnd_date.canonical_to_date (g_end_date) BETWEEN
496: paf.effective_start_date
497: AND paf.effective_end_date*/
498: ORDER BY paf.person_id,
499: pai.action_context_id,

Line 692: AND p_end_date > fnd_date.canonical_to_date(

688: AND ppa_mag.action_status = 'C'
689: AND p_gre_id = fnd_number.canonical_to_number(
690: pay_mx_utility.get_legi_param_val(cp_gre_token,
691: ppa_mag.legislative_parameters))
692: AND p_end_date > fnd_date.canonical_to_date(
693: pay_mx_utility.get_legi_param_val('END_DATE',
694: ppa_mag.legislative_parameters))
695: -- Bug 5998981
696: AND DECODE (pai.action_information_category,

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

694: ppa_mag.legislative_parameters))
695: -- Bug 5998981
696: AND DECODE (pai.action_information_category,
697: 'MX SS TRANSACTIONS',
698: TRUNC(fnd_date.canonical_to_date(pai.action_information2)),
699: hr_general.start_of_time)
700: BETWEEN TRUNC(fnd_date.canonical_to_date(
701: pay_mx_utility.get_legi_param_val('START_DATE',
702: ppa_mag.legislative_parameters)))

Line 700: BETWEEN TRUNC(fnd_date.canonical_to_date(

696: AND DECODE (pai.action_information_category,
697: 'MX SS TRANSACTIONS',
698: TRUNC(fnd_date.canonical_to_date(pai.action_information2)),
699: hr_general.start_of_time)
700: BETWEEN TRUNC(fnd_date.canonical_to_date(
701: pay_mx_utility.get_legi_param_val('START_DATE',
702: ppa_mag.legislative_parameters)))
703: AND TRUNC (fnd_date.canonical_to_date(
704: pay_mx_utility.get_legi_param_val('END_DATE',

Line 703: AND TRUNC (fnd_date.canonical_to_date(

699: hr_general.start_of_time)
700: BETWEEN TRUNC(fnd_date.canonical_to_date(
701: pay_mx_utility.get_legi_param_val('START_DATE',
702: ppa_mag.legislative_parameters)))
703: AND TRUNC (fnd_date.canonical_to_date(
704: pay_mx_utility.get_legi_param_val('END_DATE',
705: ppa_mag.legislative_parameters)))
706: ORDER BY fnd_date.canonical_to_date (pai.action_information2) DESC;
707:

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

702: ppa_mag.legislative_parameters)))
703: AND TRUNC (fnd_date.canonical_to_date(
704: pay_mx_utility.get_legi_param_val('END_DATE',
705: ppa_mag.legislative_parameters)))
706: ORDER BY fnd_date.canonical_to_date (pai.action_information2) DESC;
707:
708: l_proc_name VARCHAR2(100);
709: lv_gre_token VARCHAR2(20);
710: ln_cntr NUMBER;

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

838: AND lck.locked_action_id = pai.action_context_id*/
839: AND pai.action_context_type = 'AAP'
840: AND pai.action_information1 = cp_person_id
841: AND nvl(pai.action_information21, 'N') <> 'Y' -- Do not report flag
842: AND pai.effective_date <= fnd_date.canonical_to_date (g_end_date)
843: ORDER BY pai.effective_date DESC/*,
844: decode (paf.primary_flag, 'Y', 1, 2),
845: paf.assignment_id*/;
846:

Line 850: fnd_date.canonical_to_date (g_end_date)

846:
847: CURSOR csr_asg_actions (cp_person_id number) IS
848: /*SELECT fnd_number.canonical_to_number(
849: pay_magtape_generic.get_parameter_value ('TRANSFER_ACT_ID')),
850: fnd_date.canonical_to_date (g_end_date)
851: FROM dual
852: UNION
853: SELECT paa.assignment_action_id,
854: fnd_date.canonical_to_date(

Line 854: fnd_date.canonical_to_date(

850: fnd_date.canonical_to_date (g_end_date)
851: FROM dual
852: UNION
853: SELECT paa.assignment_action_id,
854: fnd_date.canonical_to_date(
855: pay_mx_utility.get_legi_param_val('END_DATE',
856: ppa.legislative_parameters))
857: FROM pay_payroll_actions ppa,
858: pay_assignment_actions paa,

Line 873: AND fnd_date.canonical_to_date(

869: AND ppa.action_status = 'C'
870: AND pay_mx_utility.get_legi_param_val('TRANS_GRE',
871: ppa.legislative_parameters) =
872: g_trans_gre_id
873: AND fnd_date.canonical_to_date(
874: pay_mx_utility.get_legi_param_val('END_DATE',
875: ppa.legislative_parameters)) <
876: fnd_date.canonical_to_date (g_end_date)
877: ORDER BY 2 DESC;*/

Line 876: fnd_date.canonical_to_date (g_end_date)

872: g_trans_gre_id
873: AND fnd_date.canonical_to_date(
874: pay_mx_utility.get_legi_param_val('END_DATE',
875: ppa.legislative_parameters)) <
876: fnd_date.canonical_to_date (g_end_date)
877: ORDER BY 2 DESC;*/
878:
879:
880: SELECT pai.action_context_id,

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

882: FROM pay_action_information pai
883: WHERE pai.action_information_category = 'MX SS PERSON INFORMATION'
884: AND pai.action_information1 = cp_person_id
885: -- Bug 6060070
886: AND pai.effective_date <= fnd_date.canonical_to_date (g_end_date)
887: /*AND (DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
888: fnd_date.canonical_to_date (pai.action_information2),
889: hr_general.start_of_time) BETWEEN
890: fnd_date.canonical_to_date (g_start_date)

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

884: AND pai.action_information1 = cp_person_id
885: -- Bug 6060070
886: AND pai.effective_date <= fnd_date.canonical_to_date (g_end_date)
887: /*AND (DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
888: fnd_date.canonical_to_date (pai.action_information2),
889: hr_general.start_of_time) BETWEEN
890: fnd_date.canonical_to_date (g_start_date)
891: AND fnd_date.canonical_to_date (g_end_date)
892: OR (pai.effective_date BETWEEN

Line 890: fnd_date.canonical_to_date (g_start_date)

886: AND pai.effective_date <= fnd_date.canonical_to_date (g_end_date)
887: /*AND (DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
888: fnd_date.canonical_to_date (pai.action_information2),
889: hr_general.start_of_time) BETWEEN
890: fnd_date.canonical_to_date (g_start_date)
891: AND fnd_date.canonical_to_date (g_end_date)
892: OR (pai.effective_date BETWEEN
893: fnd_date.canonical_to_date (g_start_date)
894: AND fnd_date.canonical_to_date (g_end_date)

Line 891: AND fnd_date.canonical_to_date (g_end_date)

887: /*AND (DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
888: fnd_date.canonical_to_date (pai.action_information2),
889: hr_general.start_of_time) BETWEEN
890: fnd_date.canonical_to_date (g_start_date)
891: AND fnd_date.canonical_to_date (g_end_date)
892: OR (pai.effective_date BETWEEN
893: fnd_date.canonical_to_date (g_start_date)
894: AND fnd_date.canonical_to_date (g_end_date)
895: -- Bug 6060070

Line 893: fnd_date.canonical_to_date (g_start_date)

889: hr_general.start_of_time) BETWEEN
890: fnd_date.canonical_to_date (g_start_date)
891: AND fnd_date.canonical_to_date (g_end_date)
892: OR (pai.effective_date BETWEEN
893: fnd_date.canonical_to_date (g_start_date)
894: AND fnd_date.canonical_to_date (g_end_date)
895: -- Bug 6060070
896: AND DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
897: fnd_date.canonical_to_date (pai.action_information2),

Line 894: AND fnd_date.canonical_to_date (g_end_date)

890: fnd_date.canonical_to_date (g_start_date)
891: AND fnd_date.canonical_to_date (g_end_date)
892: OR (pai.effective_date BETWEEN
893: fnd_date.canonical_to_date (g_start_date)
894: AND fnd_date.canonical_to_date (g_end_date)
895: -- Bug 6060070
896: AND DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
897: fnd_date.canonical_to_date (pai.action_information2),
898: hr_general.start_of_time) <=

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

893: fnd_date.canonical_to_date (g_start_date)
894: AND fnd_date.canonical_to_date (g_end_date)
895: -- Bug 6060070
896: AND DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
897: fnd_date.canonical_to_date (pai.action_information2),
898: hr_general.start_of_time) <=
899: fnd_date.canonical_to_date (g_end_date)
900: )
901: )

Line 899: fnd_date.canonical_to_date (g_end_date)

895: -- Bug 6060070
896: AND DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
897: fnd_date.canonical_to_date (pai.action_information2),
898: hr_general.start_of_time) <=
899: fnd_date.canonical_to_date (g_end_date)
900: )
901: )
902: /*AND fnd_date.canonical_to_date (g_end_date) BETWEEN
903: paf.effective_start_date

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

898: hr_general.start_of_time) <=
899: fnd_date.canonical_to_date (g_end_date)
900: )
901: )
902: /*AND fnd_date.canonical_to_date (g_end_date) BETWEEN
903: paf.effective_start_date
904: AND paf.effective_end_date*/
905: ORDER BY pai.effective_date DESC;
906:

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

930: AND pai.action_information4 IN ('02', '07', '08')
931: AND NVL(pai.action_information10, 'N') <> 'Y'
932: --Bug 7185703
933: AND DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
934: fnd_date.canonical_to_date (pai.action_information2),hr_general.start_of_time
935: ) >= fnd_date.canonical_to_date(cp_imp_date)
936: -- Bug 6060070
937: AND (DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
938: fnd_date.canonical_to_date (pai.action_information2),

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

931: AND NVL(pai.action_information10, 'N') <> 'Y'
932: --Bug 7185703
933: AND DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
934: fnd_date.canonical_to_date (pai.action_information2),hr_general.start_of_time
935: ) >= fnd_date.canonical_to_date(cp_imp_date)
936: -- Bug 6060070
937: AND (DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
938: fnd_date.canonical_to_date (pai.action_information2),
939: hr_general.start_of_time) BETWEEN

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

934: fnd_date.canonical_to_date (pai.action_information2),hr_general.start_of_time
935: ) >= fnd_date.canonical_to_date(cp_imp_date)
936: -- Bug 6060070
937: AND (DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
938: fnd_date.canonical_to_date (pai.action_information2),
939: hr_general.start_of_time) BETWEEN
940: fnd_date.canonical_to_date (g_start_date)
941: AND fnd_date.canonical_to_date (g_end_date)
942: OR (pai.effective_date BETWEEN

Line 940: fnd_date.canonical_to_date (g_start_date)

936: -- Bug 6060070
937: AND (DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
938: fnd_date.canonical_to_date (pai.action_information2),
939: hr_general.start_of_time) BETWEEN
940: fnd_date.canonical_to_date (g_start_date)
941: AND fnd_date.canonical_to_date (g_end_date)
942: OR (pai.effective_date BETWEEN
943: fnd_date.canonical_to_date (g_start_date)
944: AND fnd_date.canonical_to_date (g_end_date)

Line 941: AND fnd_date.canonical_to_date (g_end_date)

937: AND (DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
938: fnd_date.canonical_to_date (pai.action_information2),
939: hr_general.start_of_time) BETWEEN
940: fnd_date.canonical_to_date (g_start_date)
941: AND fnd_date.canonical_to_date (g_end_date)
942: OR (pai.effective_date BETWEEN
943: fnd_date.canonical_to_date (g_start_date)
944: AND fnd_date.canonical_to_date (g_end_date)
945: /*NOT EXISTS (SELECT 'X'

Line 943: fnd_date.canonical_to_date (g_start_date)

939: hr_general.start_of_time) BETWEEN
940: fnd_date.canonical_to_date (g_start_date)
941: AND fnd_date.canonical_to_date (g_end_date)
942: OR (pai.effective_date BETWEEN
943: fnd_date.canonical_to_date (g_start_date)
944: AND fnd_date.canonical_to_date (g_end_date)
945: /*NOT EXISTS (SELECT 'X'
946: FROM pay_payroll_actions ppa_affl,
947: pay_assignment_actions paa_affl,

Line 944: AND fnd_date.canonical_to_date (g_end_date)

940: fnd_date.canonical_to_date (g_start_date)
941: AND fnd_date.canonical_to_date (g_end_date)
942: OR (pai.effective_date BETWEEN
943: fnd_date.canonical_to_date (g_start_date)
944: AND fnd_date.canonical_to_date (g_end_date)
945: /*NOT EXISTS (SELECT 'X'
946: FROM pay_payroll_actions ppa_affl,
947: pay_assignment_actions paa_affl,
948: pay_action_interlocks lck

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

954: AND ppa_affl.report_category = 'RT'
955: AND ppa_affl.action_status = 'C')*/
956: -- Bug 6060070
957: AND DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
958: fnd_date.canonical_to_date (pai.action_information2),
959: hr_general.start_of_time) <=
960: fnd_date.canonical_to_date (g_end_date)
961: )
962: )

Line 960: fnd_date.canonical_to_date (g_end_date)

956: -- Bug 6060070
957: AND DECODE(pai.action_information_category, 'MX SS TRANSACTIONS',
958: fnd_date.canonical_to_date (pai.action_information2),
959: hr_general.start_of_time) <=
960: fnd_date.canonical_to_date (g_end_date)
961: )
962: )
963: ORDER BY fnd_date.canonical_to_date (pai.action_information2),
964: DECODE (pai.action_information4,

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

959: hr_general.start_of_time) <=
960: fnd_date.canonical_to_date (g_end_date)
961: )
962: )
963: ORDER BY fnd_date.canonical_to_date (pai.action_information2),
964: DECODE (pai.action_information4,
965: '08', 1,
966: '07', 2,
967: '02', 3);

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

1021: FETCH c_get_imp_date INTO ld_imp_date;
1022: CLOSE c_get_imp_date;
1023: hr_utility_trace ('ld_imp_date '|| ld_imp_date);
1024:
1025: SELECT fnd_date.date_to_canonical(MIN(creation_date))
1026: INTO ld_event_strt_date
1027: FROM pay_process_events ppe
1028: WHERE EXISTS
1029: (SELECT 1

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

1031: WHERE table_name IN ('PER_ALL_PEOPLE_F','PER_ALL_ASSIGNMENTS_F','PAY_ELEMENT_ENTRIES_F','PAY_ELEMENT_ENTRY_VALUES_F')
1032: AND ppe.event_update_id = peu.event_update_id
1033: );
1034:
1035: IF fnd_date.canonical_to_date(ld_event_strt_date) >= fnd_date.canonical_to_date(NVL(ld_imp_date,ld_event_strt_date)) THEN
1036: ld_imp_date := ld_event_strt_date;
1037: END IF;
1038:
1039: hr_utility_trace ('ld_event_strt_date '|| ld_event_strt_date);

Line 1123: fnd_date.canonical_to_date(g_end_date),

1119: END LOOP;
1120: CLOSE csr_transactions;
1121: process_transactions (lv_person_id,
1122: fnd_number.canonical_to_number(g_trans_gre_id),
1123: fnd_date.canonical_to_date(g_end_date),
1124: 'MX_SS_AFFL',
1125: 'MX_SS_AFFL',
1126: 'RT',
1127: lt_tran);