APPS.PER_HRTCA_MERGE dependencies on PER_PER_SHD

Line 3472: per_per_shd.lck

3468: and effective_end_date
3469: and person_id = l_ref_person_id
3470: for update nowait;
3471: /*
3472: per_per_shd.lck
3473: (p_person_id => l_person(l_count).person_id,
3474: p_datetrack_mode => l_datetrack_mode,
3475: p_object_version_number => l_person(l_count).object_version_number,
3476: p_effective_date => p_rec.effective_start_date,

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

5817: -- |----------------------------< get_party_details >-------------------------|
5818: -- ----------------------------------------------------------------------------
5819: function get_party_details
5820: (p_party_id in number,
5821: p_effective_date in date) return per_per_shd.g_rec_type is
5822: --
5823: cursor c1 is
5824: select *
5825: from per_all_people_f

Line 5832: l_rec per_per_shd.g_rec_type;

5828: between effective_start_date
5829: and effective_end_date;
5830: --
5831: l_c1 c1%rowtype;
5832: l_rec per_per_shd.g_rec_type;
5833: --
5834: begin
5835: --
5836: if nvl(fnd_profile.value('HR_PROPAGATE_DATA_CHANGES'),'N') <> 'Y' then

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

6015: --
6016: function get_person_details
6017: (p_party_id in number,
6018: p_person_id in number,
6019: p_effective_date in date) return per_per_shd.g_rec_type is
6020:
6021: --
6022: l_proc varchar2(80) := g_package||'get_person_details';
6023: --

Line 6034: l_rec per_per_shd.g_rec_type;

6030: between effective_start_date
6031: and effective_end_date;
6032: --
6033: l_c1 c1%rowtype;
6034: l_rec per_per_shd.g_rec_type;
6035: --
6036: begin
6037: --
6038: