APPS.PAY_US_REPORTING_UTILS_PKG dependencies on PER_BUSINESS_GROUPS

Line 2690: from per_business_groups o where o.organization_id = c_bus_group_id;

2686: {["'':;?/>.<, ', '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz'),1,6)||
2687: ---substr(replace(replace(replace(upper(o.short_name),'_'),' '),'-'),1,6)||
2688: 'FED'||c_report_type||
2689: substr(to_char(add_months(fnd_date.canonical_TO_DATE(c_mag_effective_date), 12) -1, 'YYYY'),3,4)
2690: from per_business_groups o where o.organization_id = c_bus_group_id;
2691:
2692: -- State W-2 Mag filenames will have following format.
2693: -- 1. Max of 6 characters Business Group Short Name (Embedded blanks will be ignored)
2694: -- 2. State Abbreviation

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 2756: from per_business_groups o where o.organization_id = c_bus_group_id;

2752: -- substr(replace(replace(replace(upper(o.short_name),'_'),' '),'-'),1,6)||
2753: decode(c_city_or_agency_code,'RTCCA','RITA','CCAAA','CCA',c_city_or_agency_code) ||
2754: 'W2'||
2755: substr(to_char(add_months(fnd_date.canonical_TO_DATE(c_mag_effective_date), 12) -1, 'YYYY'),3,4)
2756: from per_business_groups o where o.organization_id = c_bus_group_id;
2757:
2758: BEGIN
2759: l_mag_file_name := '';
2760: