APPS.PAY_US_REPORTING_UTILS_PKG dependencies on FND_DATE

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

2685: '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz~`!@#$%^\&*()_-+=|\}]
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)

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

2705: {["'':;?/>.<, ', '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz'),1,6)||
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:

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

2728: '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz~`!@#$%^\&*()_-+=|\}]
2729: {["'':;?/>.<, ', '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz'),1,6)||to_char(c_bus_group_id)||
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;

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

2751: {["'':;?/>.<, ', '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz'),1,6)||
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 := '';