99: l_legislation_code varchar2(2);
100: --
101: cursor csr_bg is
102: select legislation_code
103: from per_business_groups pbg
104: where pbg.business_group_id in (select pe.business_group_id
105: from per_all_people_f pe
106: where pe.PERSON_ID = p_person_id);
107:
330: l_legislation_code varchar2(2);
331: --
332: cursor csr_bg is
333: select legislation_code
334: from per_business_groups pbg
335: where pbg.business_group_id in (select pe.business_group_id
336: from per_previous_employers pe
337: where pe.PREVIOUS_EMPLOYER_ID = p_previous_employer_id
338: );
552:
553: -- Declare cursors and local variables
554: --
555: l_proc varchar2(72);
556: l_legislation_code per_business_groups.legislation_code%type;
557: --
558: cursor csr_bg is
559: select legislation_code
560: from per_business_groups pbg
556: l_legislation_code per_business_groups.legislation_code%type;
557: --
558: cursor csr_bg is
559: select legislation_code
560: from per_business_groups pbg
561: where pbg.business_group_id
562: in (select BUSINESS_GROUP_ID from PER_PREVIOUS_EMPLOYERS where PREVIOUS_EMPLOYER_ID =
563: p_previous_employer_id);
564: l_period_years number;
775: l_legislation_code varchar2(2);
776: --
777: cursor csr_bg is
778: select legislation_code
779: from per_business_groups pbg
780: where pbg.business_group_id in (select BUSINESS_GROUP_ID from PER_PREVIOUS_JOBS_V
781: pjb,PER_PREVIOUS_EMPLOYERS_V pem
782: where pjb.PREVIOUS_EMPLOYER_ID=pem.PREVIOUS_EMPLOYER_ID
783: and pjb.PREVIOUS_JOB_ID = p_previous_job_id);