APPS.GHR_PAY_CAPS dependencies on FND_DATE

Line 45: SELECT fnd_date.canonical_to_date(pei_information3) update34_date

41: --This function returns the date of the update 34 implemented for the retained grade employee
42: FUNCTION update34_implemented_date (p_person_id IN NUMBER)
43: RETURN DATE IS
44: CURSOR cur_update34_date is
45: SELECT fnd_date.canonical_to_date(pei_information3) update34_date
46: FROM per_people_extra_info
47: WHERE information_type = 'GHR_US_PER_UPDATE34'
48: AND person_id = p_person_id;
49:

Line 107: ,P_PEI_INFORMATION3 => fnd_date.date_to_canonical(p_date)

103: (p_person_id => p_person_id
104: ,p_information_type => 'GHR_US_PER_UPDATE34'
105: ,P_EFFECTIVE_DATE => p_date
106: ,P_PEI_information_category => 'GHR_US_PER_UPDATE34'
107: ,P_PEI_INFORMATION3 => fnd_date.date_to_canonical(p_date)
108: ,p_PERSON_EXTRA_INFO_ID => l_PERSON_EXTRA_INFO_ID
109: ,P_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER);
110: end if;
111: END update34_implement;