APPS.PAY_PAYRPENP_XML_PKG dependencies on PAY_CONSOLIDATION_SETS

Line 491: l_consolidation_set_name pay_consolidation_sets.consolidation_set_name%type;

487: l_additional_where_clause varchar2(2000);
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);

Line 521: from pay_consolidation_sets

517: --
518: cursor csr_get_consolidation_set_name(c_consolidation_set_id number)
519: is
520: select consolidation_set_name
521: from pay_consolidation_sets
522: where consolidation_set_id = c_consolidation_set_id;
523:
524: --
525: -- Cursor to get organization name.