DBA Data[Home] [Help]

APPS.GHR_PAY_CAPS dependencies on PER_PEOPLE_EXTRA_INFO

Line 46: FROM per_people_extra_info

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:
50: l_date DATE := NULL;