DBA Data[Home] [Help]

APPS.GHR_UPD_HR_VALIDATION dependencies on FND_DATE

Line 255: l_exemp_award_date := fnd_date.canonical_to_date(p_government_awards_type.date_exemp_award);

251: hr_utility.raise_error;
252: END IF;
253:
254: IF p_government_awards_type.date_exemp_award is not null then
255: l_exemp_award_date := fnd_date.canonical_to_date(p_government_awards_type.date_exemp_award);
256: l_award_date := fnd_date.canonical_to_date(p_government_awards_type.date_award_earned);
257:
258: get_rpa_info(p_pa_requests_type.pa_request_id,l_asg_end_date,l_rpa_eff_date,l_position_id);
259:

Line 256: l_award_date := fnd_date.canonical_to_date(p_government_awards_type.date_award_earned);

252: END IF;
253:
254: IF p_government_awards_type.date_exemp_award is not null then
255: l_exemp_award_date := fnd_date.canonical_to_date(p_government_awards_type.date_exemp_award);
256: l_award_date := fnd_date.canonical_to_date(p_government_awards_type.date_award_earned);
257:
258: get_rpa_info(p_pa_requests_type.pa_request_id,l_asg_end_date,l_rpa_eff_date,l_position_id);
259:
260: --Bug 2837169

Line 720: select fnd_date.canonical_to_date(rei_information11) rei_information11

716:
717: --
718: FUNCTION get_exemp_award_date(p_pa_request_id IN NUMBER) RETURN DATE IS
719: CURSOR cur_exemp_award IS
720: select fnd_date.canonical_to_date(rei_information11) rei_information11
721: from ghr_pa_request_extra_info
722: where pa_request_id = p_pa_request_id
723: and information_type = 'GHR_US_PAR_AWARDS_BONUS';
724: