APPS.PAY_US_MMRF2_W2C_FORMAT_RECORD dependencies on PAY_US_FEDERAL_TAX_INFO_F

Line 965: l_ss_tax_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;

961: return_value_csv varchar2(32767);
962: return_value_blank varchar2(32767);
963: l_err boolean;
964: l_exclude_from_output_chk boolean;
965: l_ss_tax_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
966: l_ss_wage_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
967: sp_out_1 varchar2(100);
968: sp_out_2 varchar2(100);
969:

Line 966: l_ss_wage_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;

962: return_value_blank varchar2(32767);
963: l_err boolean;
964: l_exclude_from_output_chk boolean;
965: l_ss_tax_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
966: l_ss_wage_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
967: sp_out_1 varchar2(100);
968: sp_out_2 varchar2(100);
969:
970: CURSOR GET_SS_LIMIT(c_date varchar2)

Line 974: FROM PAY_US_FEDERAL_TAX_INFO_F

970: CURSOR GET_SS_LIMIT(c_date varchar2)
971: IS
972: SELECT SS_EE_WAGE_LIMIT*100,
973: (SS_EE_WAGE_LIMIT*SS_EE_RATE)*100 tax
974: FROM PAY_US_FEDERAL_TAX_INFO_F
975: WHERE TO_DATE(C_DATE,'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE
976: AND EFFECTIVE_END_DATE
977: AND FED_INFORMATION_CATEGORY = '401K LIMITS';
978:

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

1181: CLOSE get_ss_limit;
1182: hr_utility.trace('No. rows exist for limit '||to_char(l_ss_count));
1183:
1184: IF l_ss_count = 0 THEN
1185: hr_utility.trace('No data found on PAY_US_FEDERAL_TAX_INFO_F '||
1186: 'for Social security wage limits.');
1187: ELSIF l_ss_count >1 THEN
1188: hr_utility.trace('Too many rows on PAY_US_FEDERAL_TAX_INFO_F '||
1189: 'for Social security wage limits.');

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

1184: IF l_ss_count = 0 THEN
1185: hr_utility.trace('No data found on PAY_US_FEDERAL_TAX_INFO_F '||
1186: 'for Social security wage limits.');
1187: ELSIF l_ss_count >1 THEN
1188: hr_utility.trace('Too many rows on PAY_US_FEDERAL_TAX_INFO_F '||
1189: 'for Social security wage limits.');
1190: ELSIF l_ss_count=1 THEN
1191: --{
1192: hr_utility.trace('SS Wage (Box-3 '||to_char(rcw_wage_rec(3).wage_new_value));