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 HR_GENERAL

Line 419: hr_general.start_of_time) BETWEEN

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
423: fnd_date.canonical_to_date (g_start_date)

Line 439: hr_general.start_of_time) <=

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: )
443: /*AND fnd_date.canonical_to_date (g_end_date) BETWEEN

Line 471: hr_general.start_of_time) BETWEEN

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
475: fnd_date.canonical_to_date (g_start_date)

Line 491: hr_general.start_of_time) <=

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: )
495: /*AND fnd_date.canonical_to_date (g_end_date) BETWEEN

Line 699: hr_general.start_of_time)

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)))
703: AND TRUNC (fnd_date.canonical_to_date(

Line 889: hr_general.start_of_time) BETWEEN

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
893: fnd_date.canonical_to_date (g_start_date)

Line 898: hr_general.start_of_time) <=

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: )
902: /*AND fnd_date.canonical_to_date (g_end_date) BETWEEN

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 939: hr_general.start_of_time) BETWEEN

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
943: fnd_date.canonical_to_date (g_start_date)

Line 959: hr_general.start_of_time) <=

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: )
963: ORDER BY fnd_date.canonical_to_date (pai.action_information2),