DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_UPDATE dependencies on PER_PDS_SHD

Line 3930: OR NVL(per_pds_shd.g_old_rec.adjusted_svc_date,hr_api.g_date)

3926: OR NVL(per_per_shd.g_old_rec.date_of_death,hr_api.g_date)
3927: <>NVL(p_date_of_death,hr_api.g_date)
3928: OR NVL(per_per_shd.g_old_rec.original_date_of_hire,hr_api.g_date)
3929: <>NVL(p_original_date_of_hire,hr_api.g_date)
3930: OR NVL(per_pds_shd.g_old_rec.adjusted_svc_date,hr_api.g_date)
3931: <>NVL(p_adjusted_svc_date,hr_api.g_date)
3932: OR NVL(per_per_shd.g_old_rec.town_of_birth,hr_api.g_varchar2)
3933: <>NVL(p_town_of_birth,hr_api.g_varchar2)
3934: OR NVL(per_per_shd.g_old_rec.region_of_birth,hr_api.g_varchar2)

Line 7161: per_pds_shd.lck

7157: IF p_pds_object_version_number IS NOT NULL then
7158: open csr_pds_rec(p_person_id,p_pds_hire_date);
7159: fetch csr_pds_rec into l_period_of_service_id;
7160: close csr_pds_rec;
7161: per_pds_shd.lck
7162: (p_period_of_service_id => l_period_of_service_id
7163: ,p_object_version_number => p_pds_object_version_number
7164: );
7165: END IF;