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

Line 39: ,fnd_date.canonical_to_date(pei.pei_information1) date_from

35: --
36: CURSOR cur_pei IS
37: SELECT pei.person_extra_info_id
38: -- Bug#4423679 Added date_from,date_to columns.
39: ,fnd_date.canonical_to_date(pei.pei_information1) date_from
40: ,fnd_date.canonical_to_date(pei.pei_information2) date_to
41: -- Bug#4423679
42: ,pei.pei_information3 retained_grade
43: ,pei.pei_information4 retained_step_or_rate

Line 40: ,fnd_date.canonical_to_date(pei.pei_information2) date_to

36: CURSOR cur_pei IS
37: SELECT pei.person_extra_info_id
38: -- Bug#4423679 Added date_from,date_to columns.
39: ,fnd_date.canonical_to_date(pei.pei_information1) date_from
40: ,fnd_date.canonical_to_date(pei.pei_information2) date_to
41: -- Bug#4423679
42: ,pei.pei_information3 retained_grade
43: ,pei.pei_information4 retained_step_or_rate
44: ,pei.pei_information5 retained_pay_plan

Line 52: AND p_effective_date BETWEEN NVL(fnd_date.canonical_to_date(pei.pei_information1),p_effective_date)

48: ,pei.pei_information9 retained_temp_step
49: FROM per_people_extra_info pei
50: WHERE pei.person_id = p_person_id
51: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
52: AND p_effective_date BETWEEN NVL(fnd_date.canonical_to_date(pei.pei_information1),p_effective_date)
53: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date)
54: AND fnd_date.canonical_to_date(pei.pei_information1) =
55: (SELECT MIN (NVL(fnd_date.canonical_to_date(pei2.pei_information1),p_effective_date) )
56: FROM per_people_extra_info pei2

Line 53: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date)

49: FROM per_people_extra_info pei
50: WHERE pei.person_id = p_person_id
51: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
52: AND p_effective_date BETWEEN NVL(fnd_date.canonical_to_date(pei.pei_information1),p_effective_date)
53: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date)
54: AND fnd_date.canonical_to_date(pei.pei_information1) =
55: (SELECT MIN (NVL(fnd_date.canonical_to_date(pei2.pei_information1),p_effective_date) )
56: FROM per_people_extra_info pei2
57: WHERE pei2.person_id = p_person_id

Line 54: AND fnd_date.canonical_to_date(pei.pei_information1) =

50: WHERE pei.person_id = p_person_id
51: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
52: AND p_effective_date BETWEEN NVL(fnd_date.canonical_to_date(pei.pei_information1),p_effective_date)
53: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date)
54: AND fnd_date.canonical_to_date(pei.pei_information1) =
55: (SELECT MIN (NVL(fnd_date.canonical_to_date(pei2.pei_information1),p_effective_date) )
56: FROM per_people_extra_info pei2
57: WHERE pei2.person_id = p_person_id
58: AND pei2.information_type = 'GHR_US_RETAINED_GRADE'

Line 55: (SELECT MIN (NVL(fnd_date.canonical_to_date(pei2.pei_information1),p_effective_date) )

51: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
52: AND p_effective_date BETWEEN NVL(fnd_date.canonical_to_date(pei.pei_information1),p_effective_date)
53: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date)
54: AND fnd_date.canonical_to_date(pei.pei_information1) =
55: (SELECT MIN (NVL(fnd_date.canonical_to_date(pei2.pei_information1),p_effective_date) )
56: FROM per_people_extra_info pei2
57: WHERE pei2.person_id = p_person_id
58: AND pei2.information_type = 'GHR_US_RETAINED_GRADE'
59: AND p_effective_date

Line 60: BETWEEN NVL(fnd_date.canonical_to_date(pei2.pei_information1),p_effective_date)

56: FROM per_people_extra_info pei2
57: WHERE pei2.person_id = p_person_id
58: AND pei2.information_type = 'GHR_US_RETAINED_GRADE'
59: AND p_effective_date
60: BETWEEN NVL(fnd_date.canonical_to_date(pei2.pei_information1),p_effective_date)
61: AND NVL(fnd_date.canonical_to_date(pei2.pei_information2),p_effective_date)
62: AND to_char(pei2.person_extra_info_id) NOT IN (SELECT rei_information3
63: FROM ghr_pa_request_extra_info rei
64: WHERE pa_request_id = p_pa_request_id

Line 61: AND NVL(fnd_date.canonical_to_date(pei2.pei_information2),p_effective_date)

57: WHERE pei2.person_id = p_person_id
58: AND pei2.information_type = 'GHR_US_RETAINED_GRADE'
59: AND p_effective_date
60: BETWEEN NVL(fnd_date.canonical_to_date(pei2.pei_information1),p_effective_date)
61: AND NVL(fnd_date.canonical_to_date(pei2.pei_information2),p_effective_date)
62: AND to_char(pei2.person_extra_info_id) NOT IN (SELECT rei_information3
63: FROM ghr_pa_request_extra_info rei
64: WHERE pa_request_id = p_pa_request_id
65: AND (rei_information5 is null OR rei_information5 = 'Y')

Line 69: fnd_date.canonical_to_date(rei_information6) = (select MIN (NVL(fnd_date.canonical_to_date(rei2.rei_information6),p_effective_date) )

65: AND (rei_information5 is null OR rei_information5 = 'Y')
66: --Bug # 5584845
67: AND ((information_type = 'GHR_US_PAR_TERM_RET_GRADE'
68: AND
69: fnd_date.canonical_to_date(rei_information6) = (select MIN (NVL(fnd_date.canonical_to_date(rei2.rei_information6),p_effective_date) )
70: FROM ghr_pa_request_extra_info rei2
71: WHERE pa_request_id = rei.pa_request_id
72: AND information_type = rei.information_type)
73: )

Line 86: fnd_date.canonical_to_date(rei_information6) = (select MIN (NVL(fnd_date.canonical_to_date(rei2.rei_information6),p_effective_date) )

82: AND (rei_information5 is null OR rei_information5 = 'Y')
83: --Bug # 5584845
84: AND ((information_type = 'GHR_US_PAR_TERM_RET_GRADE'
85: AND
86: fnd_date.canonical_to_date(rei_information6) = (select MIN (NVL(fnd_date.canonical_to_date(rei2.rei_information6),p_effective_date) )
87: FROM ghr_pa_request_extra_info rei2
88: WHERE pa_request_id = rei.pa_request_id
89: AND information_type = rei.information_type)
90: )

Line 231: ,fnd_date.canonical_to_date(pei.pei_information1) date_from

227: --
228: CURSOR cur_pei IS
229: SELECT pei.person_extra_info_id
230: -- Bug#4423679 Added date_from,date_to columns.
231: ,fnd_date.canonical_to_date(pei.pei_information1) date_from
232: ,fnd_date.canonical_to_date(pei.pei_information2) date_to
233: -- Bug#4423679
234: ,pei.pei_information3 retained_grade
235: ,pei.pei_information4 retained_step_or_rate

Line 232: ,fnd_date.canonical_to_date(pei.pei_information2) date_to

228: CURSOR cur_pei IS
229: SELECT pei.person_extra_info_id
230: -- Bug#4423679 Added date_from,date_to columns.
231: ,fnd_date.canonical_to_date(pei.pei_information1) date_from
232: ,fnd_date.canonical_to_date(pei.pei_information2) date_to
233: -- Bug#4423679
234: ,pei.pei_information3 retained_grade
235: ,pei.pei_information4 retained_step_or_rate
236: ,pei.pei_information5 retained_pay_plan

Line 244: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date) < p_effective_date

240: ,pei.pei_information9 retained_temp_step
241: FROM per_people_extra_info pei
242: WHERE pei.person_id = p_person_id
243: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
244: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date) < p_effective_date
245: AND fnd_date.canonical_to_date(pei.pei_information1) =
246: (SELECT MIN (NVL(fnd_date.canonical_to_date(pei2.pei_information1),p_effective_date) )
247: FROM per_people_extra_info pei2
248: WHERE pei2.person_id = p_person_id

Line 245: AND fnd_date.canonical_to_date(pei.pei_information1) =

241: FROM per_people_extra_info pei
242: WHERE pei.person_id = p_person_id
243: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
244: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date) < p_effective_date
245: AND fnd_date.canonical_to_date(pei.pei_information1) =
246: (SELECT MIN (NVL(fnd_date.canonical_to_date(pei2.pei_information1),p_effective_date) )
247: FROM per_people_extra_info pei2
248: WHERE pei2.person_id = p_person_id
249: AND pei2.information_type = 'GHR_US_RETAINED_GRADE'

Line 246: (SELECT MIN (NVL(fnd_date.canonical_to_date(pei2.pei_information1),p_effective_date) )

242: WHERE pei.person_id = p_person_id
243: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
244: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date) < p_effective_date
245: AND fnd_date.canonical_to_date(pei.pei_information1) =
246: (SELECT MIN (NVL(fnd_date.canonical_to_date(pei2.pei_information1),p_effective_date) )
247: FROM per_people_extra_info pei2
248: WHERE pei2.person_id = p_person_id
249: AND pei2.information_type = 'GHR_US_RETAINED_GRADE'
250: AND NVL(fnd_date.canonical_to_date(pei2.pei_information2),p_effective_date) < p_effective_date

Line 250: AND NVL(fnd_date.canonical_to_date(pei2.pei_information2),p_effective_date) < p_effective_date

246: (SELECT MIN (NVL(fnd_date.canonical_to_date(pei2.pei_information1),p_effective_date) )
247: FROM per_people_extra_info pei2
248: WHERE pei2.person_id = p_person_id
249: AND pei2.information_type = 'GHR_US_RETAINED_GRADE'
250: AND NVL(fnd_date.canonical_to_date(pei2.pei_information2),p_effective_date) < p_effective_date
251: AND pei2.person_extra_info_id NOT IN (SELECT rei_information3
252: FROM ghr_pa_request_extra_info
253: WHERE pa_request_id = p_pa_request_id
254: AND (rei_information5 is null OR rei_information5 = 'Y')

Line 450: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );

446: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);
447: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
448: hr_utility.set_message_token('GRADE',p_grade_or_level);
449: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
450: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
451: raise ghr_pay_calc.pay_calc_message;
452: END IF;
453: EXIT;
454: END LOOP;

Line 464: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );

460: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
461: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
462: hr_utility.set_message_token('GRADE',p_grade_or_level);
463: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
464: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
465: raise ghr_pay_calc.pay_calc_message;
466: END IF;
467: --
468:

Line 530: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );

526: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);
527: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
528: hr_utility.set_message_token('GRADE',p_grade_or_level);
529: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
530: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
531: raise ghr_pay_calc.pay_calc_message;
532: END IF;
533: EXIT;
534: END LOOP;

Line 543: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );

539: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
540: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
541: hr_utility.set_message_token('GRADE',p_grade_or_level);
542: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
543: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
544: raise ghr_pay_calc.pay_calc_message;
545: END IF;
546: --
547:

Line 641: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );

637: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);
638: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
639: hr_utility.set_message_token('GRADE',p_grade_or_level);
640: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
641: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
642: raise ghr_pay_calc.pay_calc_message;
643: END IF;
644: EXIT;
645: END IF;

Line 656: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );

652: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
653: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
654: hr_utility.set_message_token('GRADE',p_grade_or_level);
655: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
656: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
657: raise ghr_pay_calc.pay_calc_message;
658: END IF;
659: --
660: END IF; -- p_in_step_or_rate Comparison

Line 1129: AND p_effective_date BETWEEN NVL(fnd_date.canonical_to_date(pei.pei_information1),p_effective_date)

1125: ,pei.pei_information9 retained_temp_step
1126: FROM per_people_extra_info pei
1127: WHERE pei.person_id = p_pay_calc_data.person_id
1128: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
1129: AND p_effective_date BETWEEN NVL(fnd_date.canonical_to_date(pei.pei_information1),p_effective_date)
1130: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date);
1131: --Bug 3180991
1132:
1133: BEGIN

Line 1130: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date);

1126: FROM per_people_extra_info pei
1127: WHERE pei.person_id = p_pay_calc_data.person_id
1128: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
1129: AND p_effective_date BETWEEN NVL(fnd_date.canonical_to_date(pei.pei_information1),p_effective_date)
1130: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date);
1131: --Bug 3180991
1132:
1133: BEGIN
1134: