APPS.PAY_PAYRPENP_XML_PKG dependencies on PAY_PAYROLLS_F

Line 484: l_payroll_name pay_payrolls_f.payroll_name%type;

480: l_order_by_clause varchar2(200);
481: l_group_by_clause varchar2(200);
482: l_where_clause varchar2(2000);
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;

Line 508: from pay_payrolls_f

504: --
505: cursor csr_get_payroll_name (c_payroll_id number)
506: is
507: select payroll_name
508: from pay_payrolls_f
509: where payroll_id = c_payroll_id;
510:
511: --
512: -- Cursor to get consolidation_set_name