APPS.PAY_PAYRPENP_XML_PKG dependencies on PAY_PAYROLLS_F

Line 488: l_payroll_name pay_payrolls_f.payroll_name%type;

484: l_order_by_clause varchar2(200);
485: l_group_by_clause varchar2(200);
486: l_where_clause varchar2(2000);
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;

Line 512: from pay_payrolls_f

508: --
509: cursor csr_get_payroll_name (c_payroll_id number)
510: is
511: select payroll_name
512: from pay_payrolls_f
513: where payroll_id = c_payroll_id;
514:
515: --
516: -- Cursor to get consolidation_set_name