APPS.PAY_US_REPORTING_UTILS_PKG dependencies on PAY_STATE_RULES

Line 2710: from per_business_groups o, pay_state_rules psr

2706: -- substr(replace(replace(replace(upper(o.short_name),'_'),' '),'-'),1,6)||
2707: psr.state_code ||
2708: c_report_type||
2709: substr(to_char(add_months(fnd_date.canonical_to_date(c_mag_effective_date ), 12) -1, 'YYYY'),3,4)
2710: from per_business_groups o, pay_state_rules psr
2711: where o.organization_id = c_bus_group_id
2712: and psr.state_code = c_state_code;
2713:
2714: -- The SQWL (State Quarterly Wage Listing) filenames will follow the naming convention as

Line 2734: from hr_organization_units o, pay_state_rules psr

2730: -- substr(replace(replace(replace(upper(o.short_name),'_'),' '),'-'),1,6)||
2731: c_state_code ||
2732: substr(to_char(fnd_date.canonical_to_date(c_mag_effective_date ), 'MMYY'),1,4) ||
2733: c_format_type
2734: from hr_organization_units o, pay_state_rules psr
2735: where o.organization_id = c_bus_group_id
2736: and psr.state_code = c_state_code;
2737:
2738: --