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 pei2.person_extra_info_id NOT IN (SELECT rei_information3
63: FROM ghr_pa_request_extra_info
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 pei2.person_extra_info_id NOT IN (SELECT rei_information3
63: FROM ghr_pa_request_extra_info
64: WHERE pa_request_id = p_pa_request_id
65: AND (rei_information5 is null OR rei_information5 = 'Y')

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

210: --
211: CURSOR cur_pei IS
212: SELECT pei.person_extra_info_id
213: -- Bug#4423679 Added date_from,date_to columns.
214: ,fnd_date.canonical_to_date(pei.pei_information1) date_from
215: ,fnd_date.canonical_to_date(pei.pei_information2) date_to
216: -- Bug#4423679
217: ,pei.pei_information3 retained_grade
218: ,pei.pei_information4 retained_step_or_rate

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

211: CURSOR cur_pei IS
212: SELECT pei.person_extra_info_id
213: -- Bug#4423679 Added date_from,date_to columns.
214: ,fnd_date.canonical_to_date(pei.pei_information1) date_from
215: ,fnd_date.canonical_to_date(pei.pei_information2) date_to
216: -- Bug#4423679
217: ,pei.pei_information3 retained_grade
218: ,pei.pei_information4 retained_step_or_rate
219: ,pei.pei_information5 retained_pay_plan

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

223: ,pei.pei_information9 retained_temp_step
224: FROM per_people_extra_info pei
225: WHERE pei.person_id = p_person_id
226: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
227: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date) < p_effective_date
228: AND fnd_date.canonical_to_date(pei.pei_information1) =
229: (SELECT MIN (NVL(fnd_date.canonical_to_date(pei2.pei_information1),p_effective_date) )
230: FROM per_people_extra_info pei2
231: WHERE pei2.person_id = p_person_id

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

224: FROM per_people_extra_info pei
225: WHERE pei.person_id = p_person_id
226: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
227: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date) < p_effective_date
228: AND fnd_date.canonical_to_date(pei.pei_information1) =
229: (SELECT MIN (NVL(fnd_date.canonical_to_date(pei2.pei_information1),p_effective_date) )
230: FROM per_people_extra_info pei2
231: WHERE pei2.person_id = p_person_id
232: AND pei2.information_type = 'GHR_US_RETAINED_GRADE'

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

225: WHERE pei.person_id = p_person_id
226: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
227: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date) < p_effective_date
228: AND fnd_date.canonical_to_date(pei.pei_information1) =
229: (SELECT MIN (NVL(fnd_date.canonical_to_date(pei2.pei_information1),p_effective_date) )
230: FROM per_people_extra_info pei2
231: WHERE pei2.person_id = p_person_id
232: AND pei2.information_type = 'GHR_US_RETAINED_GRADE'
233: AND NVL(fnd_date.canonical_to_date(pei2.pei_information2),p_effective_date) < p_effective_date

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

229: (SELECT MIN (NVL(fnd_date.canonical_to_date(pei2.pei_information1),p_effective_date) )
230: FROM per_people_extra_info pei2
231: WHERE pei2.person_id = p_person_id
232: AND pei2.information_type = 'GHR_US_RETAINED_GRADE'
233: AND NVL(fnd_date.canonical_to_date(pei2.pei_information2),p_effective_date) < p_effective_date
234: AND pei2.person_extra_info_id NOT IN (SELECT rei_information3
235: FROM ghr_pa_request_extra_info
236: WHERE pa_request_id = p_pa_request_id
237: AND (rei_information5 is null OR rei_information5 = 'Y')

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

429: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);
430: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
431: hr_utility.set_message_token('GRADE',p_grade_or_level);
432: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
433: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
434: raise ghr_pay_calc.pay_calc_message;
435: END IF;
436: EXIT;
437: END LOOP;

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

443: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
444: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
445: hr_utility.set_message_token('GRADE',p_grade_or_level);
446: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
447: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
448: raise ghr_pay_calc.pay_calc_message;
449: END IF;
450: --
451:

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

509: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);
510: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
511: hr_utility.set_message_token('GRADE',p_grade_or_level);
512: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
513: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
514: raise ghr_pay_calc.pay_calc_message;
515: END IF;
516: EXIT;
517: END LOOP;

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

522: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
523: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
524: hr_utility.set_message_token('GRADE',p_grade_or_level);
525: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
526: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
527: raise ghr_pay_calc.pay_calc_message;
528: END IF;
529: --
530:

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

620: hr_utility.set_message_token('STEP',cur_pay_rec.step_or_rate);
621: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
622: hr_utility.set_message_token('GRADE',p_grade_or_level);
623: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
624: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
625: raise ghr_pay_calc.pay_calc_message;
626: END IF;
627: EXIT;
628: END IF;

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

635: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.get_user_table_name(p_user_table_id) );
636: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
637: hr_utility.set_message_token('GRADE',p_grade_or_level);
638: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
639: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date) );
640: raise ghr_pay_calc.pay_calc_message;
641: END IF;
642: --
643: END IF; -- p_in_step_or_rate Comparison

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

1108: ,pei.pei_information9 retained_temp_step
1109: FROM per_people_extra_info pei
1110: WHERE pei.person_id = p_pay_calc_data.person_id
1111: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
1112: AND p_effective_date BETWEEN NVL(fnd_date.canonical_to_date(pei.pei_information1),p_effective_date)
1113: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date);
1114: --Bug 3180991
1115:
1116: BEGIN

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

1109: FROM per_people_extra_info pei
1110: WHERE pei.person_id = p_pay_calc_data.person_id
1111: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
1112: AND p_effective_date BETWEEN NVL(fnd_date.canonical_to_date(pei.pei_information1),p_effective_date)
1113: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date);
1114: --Bug 3180991
1115:
1116: BEGIN
1117: