DBA Data[Home] [Help]

APPS.PAY_KR_YEA_SSHR_UTILS_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 1347: from PER_PEOPLE_EXTRA_INFO pei,

1343:
1344:
1345: cursor csr_house_holder(p_assgn_id in number, p_eff_date in date) is
1346: select nvl(pei.PEI_INFORMATION3,'N')
1347: from PER_PEOPLE_EXTRA_INFO pei,
1348: per_assignments_f paf
1349: where paf.assignment_id = p_assgn_id
1350: and p_eff_date between paf.effective_start_date and paf.effective_end_DATE
1351: and pei.person_id = paf.person_id

Line 1415: from per_people_extra_info

1411: is
1412:
1413: cursor csr_record_exist(p_per_id in varchar2) is
1414: select person_extra_info_id, object_version_number
1415: from per_people_extra_info
1416: where person_id = p_per_id
1417: and information_type = 'PER_KR_RELATED_YEA_INFORMATION';
1418:
1419: l_information_type varchar2(100);