488: l_payroll_name pay_payrolls_f.payroll_name%type;
489: l_location_code hr_locations.location_code%type;
490: l_business_group_name per_business_groups.name%type;
491: l_consolidation_set_name pay_consolidation_sets.consolidation_set_name%type;
492: l_organization_name hr_organization_units.name%type;
493: l_template_name xdo_templates_tl.template_name%type;
494: l_master_statement varchar2(32000);
495: l_detail_statement varchar2(32000);
496: l_master_column1 varchar2(60);
526: --
527: cursor csr_get_organization_name(c_organization_id number)
528: is
529: select name
530: from hr_organization_units
531: where organization_id = c_organization_id;
532:
533: --
534: --