363:
364: CURSOR c_gre_or_pre_name(p_tax_unit_id number)
365: IS
366: SELECT name
367: FROM hr_organization_units
368: WHERE organization_id = p_tax_unit_id;
369:
370: CURSOR c_person_id (c_assign_id number)
371: IS
402: CURSOR c_get_business_group_id(c_tax_unit_id number
403: )
404: IS
405: SELECT business_group_id
406: FROM hr_organization_units
407: WHERE organization_id = c_tax_unit_id;
408:
409: CURSOR c_get_missing_assignments(cp_payroll_action_id NUMBER,
410: cp_tax_unit_id NUMBER)
465: );
466:
467: lv_result_value number:=0;
468: lv_person_id per_people_f.person_id%type;
469: lv_gre_or_pre_name hr_organization_units.name%type;
470: lv_emp_name per_people_f.full_name%type;
471: lv_emp_no per_people_f.employee_number%type;
472: lv_emp_ssn per_people_f.national_identifier%type;
473: lv_data_row VARCHAR2(4000);