APPS.PAY_US_MMRF_W2_FORMAT_RECORD dependencies on PAY_US_FEDERAL_TAX_INFO_F

Line 2731: l_ss_tax_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;

2727: l_amount number(10);
2728: return_value varchar2(32767);
2729: l_err boolean;
2730: l_exclude_from_output_chk boolean;
2731: l_ss_tax_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
2732: l_ss_wage_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
2733:
2734: TYPE function_columns IS RECORD(
2735: p_parameter_name varchar2(100),

Line 2732: l_ss_wage_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;

2728: return_value varchar2(32767);
2729: l_err boolean;
2730: l_exclude_from_output_chk boolean;
2731: l_ss_tax_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
2732: l_ss_wage_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
2733:
2734: TYPE function_columns IS RECORD(
2735: p_parameter_name varchar2(100),
2736: p_parameter_value varchar2(100),

Line 2796: FROM PAY_US_FEDERAL_TAX_INFO_F

2792: CURSOR GET_SS_LIMIT(c_date varchar2)
2793: IS
2794: SELECT SS_EE_WAGE_LIMIT*100,
2795: (SS_EE_WAGE_LIMIT*SS_EE_RATE)*100 tax
2796: FROM PAY_US_FEDERAL_TAX_INFO_F
2797: WHERE TO_DATE(C_DATE,'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE
2798: AND EFFECTIVE_END_DATE
2799: AND FED_INFORMATION_CATEGORY = '401K LIMITS';
2800:

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

3144: CLOSE get_ss_limit;
3145: hr_utility.trace('No. rows exist for limit '||to_char(l_ss_count));
3146:
3147: IF l_ss_count = 0 THEN
3148: hr_utility.trace('No data found on PAY_US_FEDERAL_TAX_INFO_F '||
3149: 'for Social security wage limits.');
3150: ELSIF l_ss_count >1 THEN
3151: hr_utility.trace('Too many rows on PAY_US_FEDERAL_TAX_INFO_F '||
3152: 'for Social security wage limits.');

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

3147: IF l_ss_count = 0 THEN
3148: hr_utility.trace('No data found on PAY_US_FEDERAL_TAX_INFO_F '||
3149: 'for Social security wage limits.');
3150: ELSIF l_ss_count >1 THEN
3151: hr_utility.trace('Too many rows on PAY_US_FEDERAL_TAX_INFO_F '||
3152: 'for Social security wage limits.');
3153: ELSIF l_ss_count=1 THEN
3154: --{
3155: IF (to_number(parameter_record(3).p_output_value) > 0 OR

Line 3681: l_ss_tax_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;

3677: l_amount number(10);
3678: return_value varchar2(32767);
3679: l_err boolean;
3680: l_exclude_from_output_chk boolean;
3681: l_ss_tax_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
3682: l_ss_wage_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
3683:
3684: TYPE function_columns IS RECORD(
3685: p_parameter_name varchar2(100),

Line 3682: l_ss_wage_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;

3678: return_value varchar2(32767);
3679: l_err boolean;
3680: l_exclude_from_output_chk boolean;
3681: l_ss_tax_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
3682: l_ss_wage_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
3683:
3684: TYPE function_columns IS RECORD(
3685: p_parameter_name varchar2(100),
3686: p_parameter_value varchar2(100),

Line 4406: l_ss_tax_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;

4402: l_mif varchar2(100);
4403: l_err boolean;
4404: l_exclude_from_output_chk boolean;
4405: l_message varchar2(2000);
4406: l_ss_tax_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
4407: l_description varchar2(50);
4408: l_field_description varchar2(50);
4409: l_ss_wage_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
4410: l_ss_count number(10);

Line 4409: l_ss_wage_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;

4405: l_message varchar2(2000);
4406: l_ss_tax_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
4407: l_description varchar2(50);
4408: l_field_description varchar2(50);
4409: l_ss_wage_limit pay_us_federal_tax_info_f.ss_ee_wage_limit%TYPE;
4410: l_ss_count number(10);
4411: l_amount number(10);
4412: l_tax_ct_job_dev varchar2(30);
4413: l_tax_ct_ind_revit varchar2(30);