DBA Data[Home] [Help]

APPS.GHR_PAY_CALC dependencies on PER_PEOPLE_EXTRA_INFO

Line 606: FROM per_people_extra_info

602: SELECT pei_information3 grade,
603: pei_information4 step,
604: pei_information5 pay_plan,
605: pei_information9 temp_step
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)