DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_UPDATE dependencies on PER_PDS_SHD

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

3890: OR NVL(per_per_shd.g_old_rec.date_of_death,hr_api.g_date)
3891: <>NVL(p_date_of_death,hr_api.g_date)
3892: OR NVL(per_per_shd.g_old_rec.original_date_of_hire,hr_api.g_date)
3893: <>NVL(p_original_date_of_hire,hr_api.g_date)
3894: OR NVL(per_pds_shd.g_old_rec.adjusted_svc_date,hr_api.g_date)
3895: <>NVL(p_adjusted_svc_date,hr_api.g_date)
3896: OR NVL(per_per_shd.g_old_rec.town_of_birth,hr_api.g_varchar2)
3897: <>NVL(p_town_of_birth,hr_api.g_varchar2)
3898: OR NVL(per_per_shd.g_old_rec.region_of_birth,hr_api.g_varchar2)

Line 7121: per_pds_shd.lck

7117: IF p_pds_object_version_number IS NOT NULL then
7118: open csr_pds_rec(p_person_id,p_pds_hire_date);
7119: fetch csr_pds_rec into l_period_of_service_id;
7120: close csr_pds_rec;
7121: per_pds_shd.lck
7122: (p_period_of_service_id => l_period_of_service_id
7123: ,p_object_version_number => p_pds_object_version_number
7124: );
7125: END IF;