APPS.PAY_PAYRPENP_XML_PKG dependencies on PAY_CONSOLIDATION_SETS

Line 487: l_consolidation_set_name pay_consolidation_sets.consolidation_set_name%type;

483: l_additional_where_clause varchar2(2000);
484: l_payroll_name pay_payrolls_f.payroll_name%type;
485: l_location_code hr_locations.location_code%type;
486: l_business_group_name per_business_groups.name%type;
487: l_consolidation_set_name pay_consolidation_sets.consolidation_set_name%type;
488: l_organization_name hr_organization_units.name%type;
489: l_template_name xdo_templates_tl.template_name%type;
490: l_master_statement varchar2(32000);
491: l_detail_statement varchar2(32000);

Line 517: from pay_consolidation_sets

513: --
514: cursor csr_get_consolidation_set_name(c_consolidation_set_id number)
515: is
516: select consolidation_set_name
517: from pay_consolidation_sets
518: where consolidation_set_id = c_consolidation_set_id;
519:
520: --
521: -- Cursor to get organization name.