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
8797: select date_of_birth from per_people_f
8798: where person_id = p_person_id
8805: and ( (style='US' and region_1 is not null)
8806: or style<>'US');
8807:
8808: cursor csr_get_legc_code is
8809: select legislation_code from per_business_groups_perf
8810: where business_group_id = p_business_group_id;
8811:
8812: begin
8813: p_is_payroll_upd := false;