APPS.GHR_PAY_CALC dependencies on FND_DATE

Line 610: and c_effective_date BETWEEN NVL(fnd_date.canonical_to_date(pei_information1),c_effective_date)

606: FROM per_people_extra_info
607: where person_id = c_person_id
608: and information_type ='GHR_US_RETAINED_GRADE'
609: and pei_information_category = 'GHR_US_RETAINED_GRADE'
610: and c_effective_date BETWEEN NVL(fnd_date.canonical_to_date(pei_information1),c_effective_date)
611: AND NVL(fnd_date.canonical_to_date(pei_information2),c_effective_date);
612:
613: CURSOR c_get_rpa_details(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
614: SELECT pa_notification_id, to_step_or_rate

Line 611: AND NVL(fnd_date.canonical_to_date(pei_information2),c_effective_date);

607: where person_id = c_person_id
608: and information_type ='GHR_US_RETAINED_GRADE'
609: and pei_information_category = 'GHR_US_RETAINED_GRADE'
610: and c_effective_date BETWEEN NVL(fnd_date.canonical_to_date(pei_information1),c_effective_date)
611: AND NVL(fnd_date.canonical_to_date(pei_information2),c_effective_date);
612:
613: CURSOR c_get_rpa_details(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
614: SELECT pa_notification_id, to_step_or_rate
615: FROM ghr_pa_requests

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

775: hr_utility.set_message_token('STEP',p_step_or_rate);
776: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
777: hr_utility.set_message_token('GRADE',p_grade_or_level);
778: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
779: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date));
780: raise pay_calc_message;
781: END IF;
782: --
783: END LOOP;

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

789: hr_utility.set_message_token('STEP',p_step_or_rate);
790: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
791: hr_utility.set_message_token('GRADE',p_grade_or_level);
792: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
793: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date));
794: raise ghr_pay_calc.pay_calc_message;
795: ELSE
796: p_PT_value := l_PT_value;
797: p_PT_eff_start_date := l_PT_eff_start_date;

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

844: hr_utility.set_message_token('STEP',p_step_or_rate);
845: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
846: hr_utility.set_message_token('GRADE',p_grade_or_level);
847: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
848: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date));
849: raise pay_calc_message;
850: END IF;
851: END LOOP;
852: --

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

857: hr_utility.set_message_token('STEP',p_step_or_rate);
858: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
859: hr_utility.set_message_token('GRADE',p_grade_or_level);
860: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );
861: hr_utility.set_message_token('EFF_DATE',fnd_date.date_to_chardate(p_effective_date));
862: raise pay_calc_message;
863: ELSE
864: RETURN(l_pay_plan_value);
865: END IF;