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

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))
454: OR (pai.effective_date BETWEEN

Line 473: hr_general.start_of_time) <=

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

Line 506: hr_general.start_of_time) BETWEEN

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))
510: OR (pai.effective_date BETWEEN

Line 529: hr_general.start_of_time) <=

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

Line 809: hr_general.start_of_time)

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)))
813: AND DECODE (pai.action_information4,'08',

Line 1039: hr_general.start_of_time) BETWEEN

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

Line 1048: hr_general.start_of_time) <=

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

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

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))
1096: OR (pai.effective_date BETWEEN

Line 1115: hr_general.start_of_time) <=

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