351:
352: CURSOR c_gre_name(p_tax_unit_id number)
353: IS
354: SELECT name
355: FROM hr_organization_units
356: WHERE organization_id = p_tax_unit_id;
357:
358: CURSOR c_person_id (c_assign_id number)
359: IS
390: CURSOR c_get_business_group_id(c_tax_unit_id number
391: )
392: IS
393: SELECT business_group_id
394: FROM hr_organization_units
395: WHERE organization_id = c_tax_unit_id;
396:
397: CURSOR c_get_missing_assignments(cp_payroll_action_id NUMBER,
398: cp_tax_unit_id NUMBER)
454: );
455:
456: lv_result_value number:=0;
457: lv_person_id per_people_f.person_id%type;
458: lv_gre_name hr_organization_units.name%type;
459: lv_emp_name per_people_f.full_name%type;
460: lv_emp_no per_people_f.employee_number%type;
461: lv_emp_ssn per_people_f.national_identifier%type;
462: lv_data_row VARCHAR2(4000);