APPS.PAY_US_REPORTING_UTILS_PKG dependencies on FND_DATE

Line 2672: substr(to_char(add_months(fnd_date.canonical_TO_DATE(c_mag_effective_date), 12) -1, 'YYYY'),3,4)

2668: '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz~`!@#$%^\&*()_-+=|\}]
2669: {["'':;?/>.<, ', '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz'),1,6)||
2670: ---substr(replace(replace(replace(upper(o.short_name),'_'),' '),'-'),1,6)||
2671: 'FED'||c_report_type||
2672: substr(to_char(add_months(fnd_date.canonical_TO_DATE(c_mag_effective_date), 12) -1, 'YYYY'),3,4)
2673: from per_business_groups o where o.organization_id = c_bus_group_id;
2674:
2675: -- State W-2 Mag filenames will have following format.
2676: -- 1. Max of 6 characters Business Group Short Name (Embedded blanks will be ignored)

Line 2692: substr(to_char(add_months(fnd_date.canonical_to_date(c_mag_effective_date ), 12) -1, 'YYYY'),3,4)

2688: {["'':;?/>.<, ', '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz'),1,6)||
2689: -- substr(replace(replace(replace(upper(o.short_name),'_'),' '),'-'),1,6)||
2690: psr.state_code ||
2691: c_report_type||
2692: substr(to_char(add_months(fnd_date.canonical_to_date(c_mag_effective_date ), 12) -1, 'YYYY'),3,4)
2693: from per_business_groups o, pay_state_rules psr
2694: where o.organization_id = c_bus_group_id
2695: and psr.state_code = c_state_code;
2696:

Line 2713: substr(to_char(fnd_date.canonical_to_date(c_mag_effective_date ), 'MMYY'),1,4) ||

2709: '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz~`!@#$%^\&*()_-+=|\}]
2710: {["'':;?/>.<, ', '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz'),1,6)||
2711: -- substr(replace(replace(replace(upper(o.short_name),'_'),' '),'-'),1,6)||
2712: c_state_code ||
2713: substr(to_char(fnd_date.canonical_to_date(c_mag_effective_date ), 'MMYY'),1,4) ||
2714: c_format_type
2715: from per_business_groups o, pay_state_rules psr
2716: where o.organization_id = c_bus_group_id
2717: and psr.state_code = c_state_code;

Line 2736: substr(to_char(add_months(fnd_date.canonical_TO_DATE(c_mag_effective_date), 12) -1, 'YYYY'),3,4)

2732: {["'':;?/>.<, ', '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz'),1,6)||
2733: -- substr(replace(replace(replace(upper(o.short_name),'_'),' '),'-'),1,6)||
2734: decode(c_city_or_agency_code,'RTCCA','RITA','CCAAA','CCA',c_city_or_agency_code) ||
2735: 'W2'||
2736: substr(to_char(add_months(fnd_date.canonical_TO_DATE(c_mag_effective_date), 12) -1, 'YYYY'),3,4)
2737: from per_business_groups o where o.organization_id = c_bus_group_id;
2738:
2739: BEGIN
2740: l_mag_file_name := '';