APPS.PAY_US_MMRF_W2_FORMAT_RECORD dependencies on PAY_US_FEDERAL_TAX_INFO_F

Line 2192: l_ss_tax_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;

2188: l_amount number(10);
2189: return_value varchar2(32767);
2190: l_err boolean;
2191: l_exclude_from_output_chk boolean;
2192: l_ss_tax_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
2193: l_ss_wage_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
2194:
2195: TYPE function_columns IS RECORD(
2196: p_parameter_name varchar2(100),

Line 2193: l_ss_wage_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;

2189: return_value varchar2(32767);
2190: l_err boolean;
2191: l_exclude_from_output_chk boolean;
2192: l_ss_tax_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
2193: l_ss_wage_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
2194:
2195: TYPE function_columns IS RECORD(
2196: p_parameter_name varchar2(100),
2197: p_parameter_value varchar2(100),

Line 2255: FROM PAY_US_FEDERAL_TAX_INFO_F

2251: CURSOR GET_SS_LIMIT(c_date varchar2)
2252: IS
2253: SELECT SS_EE_WAGE_LIMIT*100,
2254: (SS_EE_WAGE_LIMIT*SS_EE_RATE)*100 tax
2255: FROM PAY_US_FEDERAL_TAX_INFO_F
2256: WHERE TO_DATE(C_DATE,'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE
2257: AND EFFECTIVE_END_DATE
2258: AND FED_INFORMATION_CATEGORY = '401K LIMITS';
2259:

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

2595: CLOSE get_ss_limit;
2596: hr_utility.trace('No. rows exist for limit '||to_char(l_ss_count));
2597:
2598: IF l_ss_count = 0 THEN
2599: hr_utility.trace('No data found on PAY_US_FEDERAL_TAX_INFO_F '||
2600: 'for Social security wage limits.');
2601: ELSIF l_ss_count >1 THEN
2602: hr_utility.trace('Too many rows on PAY_US_FEDERAL_TAX_INFO_F '||
2603: 'for Social security wage limits.');

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

2598: IF l_ss_count = 0 THEN
2599: hr_utility.trace('No data found on PAY_US_FEDERAL_TAX_INFO_F '||
2600: 'for Social security wage limits.');
2601: ELSIF l_ss_count >1 THEN
2602: hr_utility.trace('Too many rows on PAY_US_FEDERAL_TAX_INFO_F '||
2603: 'for Social security wage limits.');
2604: ELSIF l_ss_count=1 THEN
2605: --{
2606: IF (to_number(parameter_record(3).p_output_value) > 0 OR

Line 3060: l_ss_tax_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;

3056: l_amount number(10);
3057: return_value varchar2(32767);
3058: l_err boolean;
3059: l_exclude_from_output_chk boolean;
3060: l_ss_tax_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
3061: l_ss_wage_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
3062:
3063: TYPE function_columns IS RECORD(
3064: p_parameter_name varchar2(100),

Line 3061: l_ss_wage_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;

3057: return_value varchar2(32767);
3058: l_err boolean;
3059: l_exclude_from_output_chk boolean;
3060: l_ss_tax_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
3061: l_ss_wage_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
3062:
3063: TYPE function_columns IS RECORD(
3064: p_parameter_name varchar2(100),
3065: p_parameter_value varchar2(100),

Line 3736: l_ss_tax_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;

3732: l_mif varchar2(100);
3733: l_err boolean;
3734: l_exclude_from_output_chk boolean;
3735: l_message varchar2(2000);
3736: l_ss_tax_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
3737: l_description varchar2(50);
3738: l_field_description varchar2(50);
3739: l_ss_wage_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
3740: l_ss_count number(10);

Line 3739: l_ss_wage_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;

3735: l_message varchar2(2000);
3736: l_ss_tax_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
3737: l_description varchar2(50);
3738: l_field_description varchar2(50);
3739: l_ss_wage_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
3740: l_ss_count number(10);
3741: l_amount number(10);
3742: l_tax_ct_job_dev varchar2(30);
3743: l_tax_ct_ind_revit varchar2(30);