[Home] [Help]
1135: /* Variables used to hold the current values returned within the loop for
1136: checking against the new values returned from within the loop on the
1137: next iteration. */
1138: l_prev_person_id per_people_f.person_id%type;
1139: l_prev_tax_unit_id hr_organization_units.organization_id%type;
1140:
1141: /* Variable to hold the jurisdiction code used as a context for state
1142: reporting. */
1143: l_jurisdiction_code varchar2(30);
4476:
4477: l_processed varchar2(20);
4478: l_mesg varchar2(100);
4479:
4480: l_gre_name hr_organization_units.name%TYPE;
4481:
4482: BEGIN
4483:
4484: l_step := 1;
4514: l_processed := 'Z';
4515:
4516: select hou.name into l_gre_name
4517: from hr_organization_information hoi,
4518: hr_organization_units hou
4519: where hoi.org_information_context = 'CLASS'
4520: and hoi.org_information1 = 'HR_LEGAL'
4521: and hoi.organization_id = hou.organization_id
4522: and hou.business_group_id = l_eoy_bg_id