[Home] [Help]
96: ,per.npw_number
97: ,bus.business_group_id
98: ,bus.legislation_code
99: FROM per_people_f per
100: ,per_business_groups bus
101: ,per_person_types pet
102: WHERE per.person_type_id = pet.person_type_id
103: AND per.business_group_id+0 = bus.business_group_id
104: AND per.person_id = csr_per_details.p_person_id
1718: l_primary_assignment_id number:=p_primary_assignment_id;
1719: --
1720: l_system_person_type per_person_types.system_person_type%TYPE;
1721: l_business_group_id per_all_people_f.business_group_id%TYPE;
1722: l_legislation_code per_business_groups.legislation_code%TYPE;
1723: l_application_id per_applications.application_id%TYPE;
1724: l_apl_object_version_number per_applications.application_id%TYPE;
1725: --
1726: l_hire_date date;
1803: per.npw_number,
1804: pap.application_id,
1805: pap.object_version_number
1806: from per_all_people_f per,
1807: per_business_groups bus,
1808: per_person_types ppt,
1809: per_applications pap
1810: where per.person_type_id = ppt.person_type_id
1811: and per.business_group_id = bus.business_group_id
4183: l_primary_assignment_id number:=p_primary_assignment_id;
4184: --
4185: l_system_person_type per_person_types.system_person_type%TYPE;
4186: l_business_group_id per_all_people_f.business_group_id%TYPE;
4187: l_legislation_code per_business_groups.legislation_code%TYPE;
4188: l_application_id per_applications.application_id%TYPE;
4189: l_apl_object_version_number per_applications.application_id%TYPE;
4190: --
4191: l_hire_date date;
4276: per.npw_number,
4277: pap.application_id,
4278: pap.object_version_number
4279: from per_all_people_f per,
4280: per_business_groups bus,
4281: per_person_types ppt,
4282: per_applications pap
4283: where per.person_type_id = ppt.person_type_id
4284: and per.business_group_id = bus.business_group_id