APPS.PAY_US_MMRF2_W2C_FORMAT_RECORD dependencies on PAY_US_FEDERAL_TAX_INFO_F

Line 985: l_ss_tax_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;

981: return_value_csv varchar2(32767);
982: return_value_blank varchar2(32767);
983: l_err boolean;
984: l_exclude_from_output_chk boolean;
985: l_ss_tax_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
986: l_ss_wage_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
987: sp_out_1 varchar2(100);
988: sp_out_2 varchar2(100);
989:

Line 986: l_ss_wage_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;

982: return_value_blank varchar2(32767);
983: l_err boolean;
984: l_exclude_from_output_chk boolean;
985: l_ss_tax_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
986: l_ss_wage_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
987: sp_out_1 varchar2(100);
988: sp_out_2 varchar2(100);
989:
990: CURSOR GET_SS_LIMIT(c_date varchar2)

Line 994: FROM PAY_US_FEDERAL_TAX_INFO_F

990: CURSOR GET_SS_LIMIT(c_date varchar2)
991: IS
992: SELECT SS_EE_WAGE_LIMIT*100,
993: (SS_EE_WAGE_LIMIT*SS_EE_RATE)*100 tax
994: FROM PAY_US_FEDERAL_TAX_INFO_F
995: WHERE TO_DATE(C_DATE,'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE
996: AND EFFECTIVE_END_DATE
997: AND FED_INFORMATION_CATEGORY = '401K LIMITS';
998:

Line 1206: hr_utility.trace('No data found on PAY_US_FEDERAL_TAX_INFO_F '||

1202: CLOSE get_ss_limit;
1203: hr_utility.trace('No. rows exist for limit '||to_char(l_ss_count));
1204:
1205: IF l_ss_count = 0 THEN
1206: hr_utility.trace('No data found on PAY_US_FEDERAL_TAX_INFO_F '||
1207: 'for Social security wage limits.');
1208: ELSIF l_ss_count >1 THEN
1209: hr_utility.trace('Too many rows on PAY_US_FEDERAL_TAX_INFO_F '||
1210: 'for Social security wage limits.');

Line 1209: hr_utility.trace('Too many rows on PAY_US_FEDERAL_TAX_INFO_F '||

1205: IF l_ss_count = 0 THEN
1206: hr_utility.trace('No data found on PAY_US_FEDERAL_TAX_INFO_F '||
1207: 'for Social security wage limits.');
1208: ELSIF l_ss_count >1 THEN
1209: hr_utility.trace('Too many rows on PAY_US_FEDERAL_TAX_INFO_F '||
1210: 'for Social security wage limits.');
1211: ELSIF l_ss_count=1 THEN
1212: --{
1213: hr_utility.trace('SS Wage (Box-3 '||to_char(rcw_wage_rec(3).wage_new_value));