APPS.PER_HRTCA_MERGE dependencies on PER_PER_SHD

Line 3487: per_per_shd.lck

3483: and effective_end_date
3484: and person_id = l_ref_person_id
3485: for update nowait;
3486: /*
3487: per_per_shd.lck
3488: (p_person_id => l_person(l_count).person_id,
3489: p_datetrack_mode => l_datetrack_mode,
3490: p_object_version_number => l_person(l_count).object_version_number,
3491: p_effective_date => p_rec.effective_start_date,

Line 5840: p_effective_date in date) return per_per_shd.g_rec_type is

5836: -- |----------------------------< get_party_details >-------------------------|
5837: -- ----------------------------------------------------------------------------
5838: function get_party_details
5839: (p_party_id in number,
5840: p_effective_date in date) return per_per_shd.g_rec_type is
5841: --
5842: cursor c1 is
5843: select *
5844: from per_all_people_f

Line 5851: l_rec per_per_shd.g_rec_type;

5847: between effective_start_date
5848: and effective_end_date;
5849: --
5850: l_c1 c1%rowtype;
5851: l_rec per_per_shd.g_rec_type;
5852: --
5853: begin
5854: --
5855: if nvl(fnd_profile.value('HR_PROPAGATE_DATA_CHANGES'),'N') <> 'Y' then

Line 6039: p_effective_date in date) return per_per_shd.g_rec_type is

6035: --
6036: function get_person_details
6037: (p_party_id in number,
6038: p_person_id in number,
6039: p_effective_date in date) return per_per_shd.g_rec_type is
6040:
6041: --
6042: l_proc varchar2(80) := g_package||'get_person_details';
6043: --

Line 6054: l_rec per_per_shd.g_rec_type;

6050: between effective_start_date
6051: and effective_end_date;
6052: --
6053: l_c1 c1%rowtype;
6054: l_rec per_per_shd.g_rec_type;
6055: --
6056: begin
6057: --
6058: