APPS.PER_ASG_BUS2 dependencies on PER_ADDRESSES

Line 178: from per_addresses

174: l_proc varchar2(72) := g_package||'chk_payroll_id';
175: --
176: cursor csr_pradd_exists is
177: select address_line1
178: from per_addresses
179: where person_id = p_person_id
180: and primary_flag='Y'
181: and ( (style='US' and region_1 is not null)
182: or style<>'US');

Line 184: l_address_line1 per_addresses.address_line1%type;

180: and primary_flag='Y'
181: and ( (style='US' and region_1 is not null)
182: or style<>'US');
183: --
184: l_address_line1 per_addresses.address_line1%type;
185: --
186: cursor csr_get_person_dob is
187: select date_of_birth
188: from per_people_f

Line 247: ,p_address_line1 in per_addresses.address_line1%type

243: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
244: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
245: ,p_effective_date in date
246: ,p_datetrack_mode in varchar2
247: ,p_address_line1 in per_addresses.address_line1%type
248: ,p_date_of_birth in per_all_people_f.date_of_birth%type
249: ,p_payroll_id_updated out nocopy boolean
250: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
251: )

Line 369: from per_addresses a

365: --
366: -- fix for bug 10040024
367: cursor csr_add_style is
368: select style
369: from per_addresses a
370: where a.person_id = p_person_id and a.primary_flag = 'Y'
371: and p_effective_date between a.date_from and nvl(a.date_to,hr_api.g_eot);
372: l_style per_addresses.style%TYPE;
373: -- end of fix 10040024

Line 372: l_style per_addresses.style%TYPE;

368: select style
369: from per_addresses a
370: where a.person_id = p_person_id and a.primary_flag = 'Y'
371: and p_effective_date between a.date_from and nvl(a.date_to,hr_api.g_eot);
372: l_style per_addresses.style%TYPE;
373: -- end of fix 10040024
374: --
375: begin
376: hr_utility.set_location('Entering:'|| l_proc, 10);