2292: l_procedure VARCHAR2(100);
2293: l_open_tag VARCHAR2(100);
2294: l_gre_id hr_organization_units.organization_id%TYPE;
2295: l_action_context_id pay_assignment_actions.assignment_action_id%TYPE;
2296: l_emp_number per_people_f.employee_number%TYPE;
2297: l_emp_count NUMBER;
2298: l_start_date DATE;
2299: l_end_date DATE;
2300: l_source_id NUMBER;
2549: l_procedure VARCHAR2(100);
2550: l_open_tag VARCHAR2(100);
2551: l_gre_id hr_organization_units.organization_id%TYPE;
2552: l_action_context_id pay_assignment_actions.assignment_action_id%TYPE;
2553: l_emp_number per_people_f.employee_number%TYPE;
2554: l_emp_count NUMBER;
2555: l_start_date DATE;
2556: l_end_date DATE;
2557: l_source_id NUMBER;
2555: l_start_date DATE;
2556: l_end_date DATE;
2557: l_source_id NUMBER;
2558: l_flag_for_16aa NUMBER;
2559: --l_emp_id per_people_f.employee_number%TYPE;
2560:
2561:
2562: CURSOR csr_fetch_gre( p_gre_id IN hr_organization_units.organization_id%TYPE)
2563: IS