DBA Data[Home] [Help]

APPS.HR_PROCESS_PERSON_SS dependencies on PER_ADDRESSES

Line 8792: l_address_line1 per_addresses.address_line1%type;

8788: ,p_assignment_id in number
8789: ,p_is_payroll_upd out nocopy boolean
8790: ) is
8791:
8792: l_address_line1 per_addresses.address_line1%type;
8793: l_date_of_birth per_all_people_f.date_of_birth%type;
8794: l_legislation_code per_business_groups.legislation_code%TYPE;
8795:
8796: cursor csr_get_person_dob is

Line 8803: select address_line1 from per_addresses

8799: and p_effective_date between effective_start_date
8800: and effective_end_date;
8801:
8802: cursor csr_pradd_exists is
8803: select address_line1 from per_addresses
8804: where person_id = p_person_id and primary_flag='Y'
8805: and ( (style='US' and region_1 is not null)
8806: or style<>'US');
8807: