DBA Data[Home] [Help]

APPS.PAY_KR_YEA_SSHR_UTILS_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 2069: from PER_PEOPLE_EXTRA_INFO pei,

2065:
2066:
2067: cursor csr_house_holder(p_assgn_id in number, p_eff_date in date) is
2068: select nvl(pei.PEI_INFORMATION3,'N')
2069: from PER_PEOPLE_EXTRA_INFO pei,
2070: per_assignments_f paf
2071: where paf.assignment_id = p_assgn_id
2072: and p_eff_date between paf.effective_start_date and paf.effective_end_DATE
2073: and pei.person_id = paf.person_id

Line 2168: from per_people_extra_info

2164: is
2165:
2166: cursor csr_record_exist(p_per_id in varchar2) is
2167: select person_extra_info_id, object_version_number
2168: from per_people_extra_info
2169: where person_id = p_per_id
2170: and information_type = 'PER_KR_RELATED_YEA_INFORMATION';
2171:
2172: l_information_type varchar2(100);