eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CN_DEDUCTIONS dependencies on HR_ORGANIZATION_INFORMATION

Line 46: FROM hr_organization_information hoi

42: --
43: CURSOR c_phf_high_limit_exempt
44: IS
45: SELECT org_information2 -- Y/N
46: FROM hr_organization_information hoi
47: WHERE hoi.organization_id = p_employer_id
48: AND hoi.org_information_context = 'PER_PHF_STAT_INFO_CN'
49: AND hoi.org_information1 = p_contribution_area;
50:

Line 114: l_tax_method hr_organization_information.org_information3%type;

110: , p_special_payment_type IN VARCHAR2
111: )
112: RETURN VARCHAR2
113: IS
114: l_tax_method hr_organization_information.org_information3%type;
115: l_special_payment_type_id pay_element_classifications.classification_id%type;
116:
117: CURSOR csr_sp_pay_id ( p_special_payment_type IN VARCHAR2 ) IS
118: SELECT pri.classification_id

Line 132: FROM hr_organization_information hoi

128: , p_tax_area VARCHAR2
129: , p_special_payment_type_id NUMBER
130: ) IS
131: SELECT hoi.org_information3
132: FROM hr_organization_information hoi
133: ,per_all_assignments paf
134: ,hr_soft_coding_keyflex hsc
135: ,hr_all_organization_units hou
136: WHERE paf.assignment_id = p_assignment_id

Line 784: FROM hr_organization_information

780: ,fnd_number.canonical_to_number(org_information14) -- Average Salary
781: ,fnd_number.canonical_to_number(org_information17) -- EE Fixed Amount
782: ,fnd_number.canonical_to_number(org_information18) -- ER Fixed Amount
783: ,fnd_number.canonical_to_number(org_information19) -- EE/ER Tax Threshold amount for bug 6828199
784: FROM hr_organization_information
785: WHERE org_information_context = 'PER_CONT_AREA_CONT_BASE_CN'
786: AND organization_id = p_business_group_id
787: AND p_effective_date BETWEEN to_date(org_information15,'YYYY/MM/DD HH24:MI:SS')
788: AND to_date(nvl(org_information16,'4712/12/31 00:00:00'),'YYYY/MM/DD HH24:MI:SS')

Line 812: FROM hr_organization_information

808: --
809: ,fnd_number.canonical_to_number(org_information17) -- EE Fixed Amount
810: ,fnd_number.canonical_to_number(org_information18) -- ER Fixed Amount
811: ,fnd_number.canonical_to_number(org_information19) -- EE/ER Tax Threshold amount for bug 6828199
812: FROM hr_organization_information
813: WHERE org_information_context = 'PER_CONT_AREA_CONT_BASE_CN'
814: AND organization_id = p_business_group_id
815: AND p_effective_date BETWEEN to_date(org_information15,'YYYY/MM/DD HH24:MI:SS')
816: AND to_date(nvl(org_information16,'4712/12/31 00:00:00'),'YYYY/MM/DD HH24:MI:SS')

Line 1052: FROM hr_organization_information

1048: ,org_information8 -- EE Rounding Method
1049: ,org_information12 -- ER Rounding Method
1050: ,fnd_number.canonical_to_number(org_information13) -- EE Tax Threshold rate for bug 6828199
1051: ,fnd_number.canonical_to_number(org_information14) -- ER Tax thershold rate for bug 6828199
1052: FROM hr_organization_information
1053: WHERE org_information_context = 'PER_CONT_AREA_PHF_SI_RATES_CN'
1054: AND organization_id = p_business_group_id
1055: AND p_effective_date BETWEEN to_date(org_information10,'YYYY/MM/DD HH24:MI:SS')
1056: AND to_date(nvl(org_information11,'4712/12/31 00:00:00'),'YYYY/MM/DD HH24:MI:SS')

Line 1072: FROM hr_organization_information

1068: ,org_information8 -- EE Rounding Method
1069: ,org_information12 -- ER Rounding Method
1070: ,fnd_number.canonical_to_number(org_information13) -- EE Tax Threshold rate for bug 6828199
1071: ,fnd_number.canonical_to_number(org_information14) -- ER Tax thershold rate for bug 6828199
1072: FROM hr_organization_information
1073: WHERE org_information_context = 'PER_CONT_AREA_PHF_SI_RATES_CN'
1074: AND organization_id = p_business_group_id
1075: AND p_effective_date BETWEEN to_date(org_information10,'YYYY/MM/DD HH24:MI:SS')
1076: AND to_date(nvl(org_information11,'4712/12/31 00:00:00'),'YYYY/MM/DD HH24:MI:SS')

Line 1092: FROM hr_organization_information

1088: ,org_information8 -- EE Rounding Method
1089: ,org_information12 -- ER Rounding Method
1090: ,fnd_number.canonical_to_number(org_information13) -- EE Tax Threshold rate for bug 6828199
1091: ,fnd_number.canonical_to_number(org_information14) -- ER Tax thershold rate for bug 6828199
1092: FROM hr_organization_information
1093: WHERE org_information_context = 'PER_CONT_AREA_PHF_SI_RATES_CN'
1094: AND organization_id = p_business_group_id
1095: AND p_effective_date BETWEEN to_date(org_information10,'YYYY/MM/DD HH24:MI:SS')
1096: AND to_date(nvl(org_information11,'4712/12/31 00:00:00'),'YYYY/MM/DD HH24:MI:SS')

Line 1112: FROM hr_organization_information

1108: ,org_information8 -- EE Rounding Method
1109: ,org_information12 -- ER Rounding Method
1110: ,fnd_number.canonical_to_number(org_information13) -- EE Tax Threshold rate for bug 6828199
1111: ,fnd_number.canonical_to_number(org_information14) -- ER Tax thershold rate for bug 6828199
1112: FROM hr_organization_information
1113: WHERE org_information_context = 'PER_CONT_AREA_PHF_SI_RATES_CN'
1114: AND organization_id = p_business_group_id
1115: AND p_effective_date BETWEEN to_date(org_information10,'YYYY/MM/DD HH24:MI:SS')
1116: AND to_date(nvl(org_information11,'4712/12/31 00:00:00'),'YYYY/MM/DD HH24:MI:SS')

Line 1178: FROM hr_organization_information

1174: CURSOR c_annuity_round
1175: IS
1176: SELECT org_information1 -- EE Rounding Method
1177: , org_information2 -- ER Rounding Method
1178: FROM hr_organization_information
1179: WHERE org_information_context = 'PER_ORG_ANNUITY_ROUND_CN'
1180: AND organization_id = p_business_group_id;
1181:
1182: --

Line 3334: l_ee_cont_base_method hr_organization_information.org_information1%type;

3330: l_er_stat_percentage NUMBER;
3331:
3332: g_procedure_name VARCHAR2(50);
3333:
3334: l_ee_cont_base_method hr_organization_information.org_information1%type;
3335: l_er_cont_base_method hr_organization_information.org_information1%type;
3336: l_low_limit_method hr_organization_information.org_information1%type;
3337: l_high_limit_method hr_organization_information.org_information1%type;
3338: l_low_limit_amount NUMBER;

Line 3335: l_er_cont_base_method hr_organization_information.org_information1%type;

3331:
3332: g_procedure_name VARCHAR2(50);
3333:
3334: l_ee_cont_base_method hr_organization_information.org_information1%type;
3335: l_er_cont_base_method hr_organization_information.org_information1%type;
3336: l_low_limit_method hr_organization_information.org_information1%type;
3337: l_high_limit_method hr_organization_information.org_information1%type;
3338: l_low_limit_amount NUMBER;
3339: l_high_limit_amount NUMBER;

Line 3336: l_low_limit_method hr_organization_information.org_information1%type;

3332: g_procedure_name VARCHAR2(50);
3333:
3334: l_ee_cont_base_method hr_organization_information.org_information1%type;
3335: l_er_cont_base_method hr_organization_information.org_information1%type;
3336: l_low_limit_method hr_organization_information.org_information1%type;
3337: l_high_limit_method hr_organization_information.org_information1%type;
3338: l_low_limit_amount NUMBER;
3339: l_high_limit_amount NUMBER;
3340: l_tax_thrhld_amount NUMBER; -- for bug 6828199

Line 3337: l_high_limit_method hr_organization_information.org_information1%type;

3333:
3334: l_ee_cont_base_method hr_organization_information.org_information1%type;
3335: l_er_cont_base_method hr_organization_information.org_information1%type;
3336: l_low_limit_method hr_organization_information.org_information1%type;
3337: l_high_limit_method hr_organization_information.org_information1%type;
3338: l_low_limit_amount NUMBER;
3339: l_high_limit_amount NUMBER;
3340: l_tax_thrhld_amount NUMBER; -- for bug 6828199
3341: l_switch_periodicity hr_organization_information.org_information1%type;

Line 3341: l_switch_periodicity hr_organization_information.org_information1%type;

3337: l_high_limit_method hr_organization_information.org_information1%type;
3338: l_low_limit_amount NUMBER;
3339: l_high_limit_amount NUMBER;
3340: l_tax_thrhld_amount NUMBER; -- for bug 6828199
3341: l_switch_periodicity hr_organization_information.org_information1%type;
3342: l_switch_month hr_organization_information.org_information1%type;
3343: l_base_rounding_method hr_organization_information.org_information1%type;
3344: l_lowest_avg_salary NUMBER;
3345: l_average_salary NUMBER;

Line 3342: l_switch_month hr_organization_information.org_information1%type;

3338: l_low_limit_amount NUMBER;
3339: l_high_limit_amount NUMBER;
3340: l_tax_thrhld_amount NUMBER; -- for bug 6828199
3341: l_switch_periodicity hr_organization_information.org_information1%type;
3342: l_switch_month hr_organization_information.org_information1%type;
3343: l_base_rounding_method hr_organization_information.org_information1%type;
3344: l_lowest_avg_salary NUMBER;
3345: l_average_salary NUMBER;
3346: l_ee_fixed_amount NUMBER;

Line 3343: l_base_rounding_method hr_organization_information.org_information1%type;

3339: l_high_limit_amount NUMBER;
3340: l_tax_thrhld_amount NUMBER; -- for bug 6828199
3341: l_switch_periodicity hr_organization_information.org_information1%type;
3342: l_switch_month hr_organization_information.org_information1%type;
3343: l_base_rounding_method hr_organization_information.org_information1%type;
3344: l_lowest_avg_salary NUMBER;
3345: l_average_salary NUMBER;
3346: l_ee_fixed_amount NUMBER;
3347: l_er_fixed_amount NUMBER;

Line 3348: l_ee_rate_type hr_organization_information.org_information1%type;

3344: l_lowest_avg_salary NUMBER;
3345: l_average_salary NUMBER;
3346: l_ee_fixed_amount NUMBER;
3347: l_er_fixed_amount NUMBER;
3348: l_ee_rate_type hr_organization_information.org_information1%type;
3349: l_er_rate_type hr_organization_information.org_information1%type;
3350: l_ee_rate NUMBER;
3351: l_er_rate NUMBER;
3352: l_ee_thrhld_rate NUMBER; -- for bug 6828199

Line 3349: l_er_rate_type hr_organization_information.org_information1%type;

3345: l_average_salary NUMBER;
3346: l_ee_fixed_amount NUMBER;
3347: l_er_fixed_amount NUMBER;
3348: l_ee_rate_type hr_organization_information.org_information1%type;
3349: l_er_rate_type hr_organization_information.org_information1%type;
3350: l_ee_rate NUMBER;
3351: l_er_rate NUMBER;
3352: l_ee_thrhld_rate NUMBER; -- for bug 6828199
3353: l_er_thrhld_rate NUMBER; -- for bug 6828199

Line 3354: l_ee_rate_rounding_method hr_organization_information.org_information1%type;

3350: l_ee_rate NUMBER;
3351: l_er_rate NUMBER;
3352: l_ee_thrhld_rate NUMBER; -- for bug 6828199
3353: l_er_thrhld_rate NUMBER; -- for bug 6828199
3354: l_ee_rate_rounding_method hr_organization_information.org_information1%type;
3355: l_er_rate_rounding_method hr_organization_information.org_information1%type;
3356: l_defer_deductions hr_organization_information.org_information1%type;
3357: l_deduct_in_probation_expiry hr_organization_information.org_information1%type;
3358:

Line 3355: l_er_rate_rounding_method hr_organization_information.org_information1%type;

3351: l_er_rate NUMBER;
3352: l_ee_thrhld_rate NUMBER; -- for bug 6828199
3353: l_er_thrhld_rate NUMBER; -- for bug 6828199
3354: l_ee_rate_rounding_method hr_organization_information.org_information1%type;
3355: l_er_rate_rounding_method hr_organization_information.org_information1%type;
3356: l_defer_deductions hr_organization_information.org_information1%type;
3357: l_deduct_in_probation_expiry hr_organization_information.org_information1%type;
3358:
3359: l_message VARCHAR2(1000);

Line 3356: l_defer_deductions hr_organization_information.org_information1%type;

3352: l_ee_thrhld_rate NUMBER; -- for bug 6828199
3353: l_er_thrhld_rate NUMBER; -- for bug 6828199
3354: l_ee_rate_rounding_method hr_organization_information.org_information1%type;
3355: l_er_rate_rounding_method hr_organization_information.org_information1%type;
3356: l_defer_deductions hr_organization_information.org_information1%type;
3357: l_deduct_in_probation_expiry hr_organization_information.org_information1%type;
3358:
3359: l_message VARCHAR2(1000);
3360: l_recalculate_flag VARCHAR2(1);

Line 3357: l_deduct_in_probation_expiry hr_organization_information.org_information1%type;

3353: l_er_thrhld_rate NUMBER; -- for bug 6828199
3354: l_ee_rate_rounding_method hr_organization_information.org_information1%type;
3355: l_er_rate_rounding_method hr_organization_information.org_information1%type;
3356: l_defer_deductions hr_organization_information.org_information1%type;
3357: l_deduct_in_probation_expiry hr_organization_information.org_information1%type;
3358:
3359: l_message VARCHAR2(1000);
3360: l_recalculate_flag VARCHAR2(1);
3361:

Line 4494: l_ee_cont_base_method hr_organization_information.org_information1%type;

4490: IS
4491: l_message VARCHAR2(255);
4492: l_dimension VARCHAR2(10);
4493:
4494: l_ee_cont_base_method hr_organization_information.org_information1%type;
4495: l_er_cont_base_method hr_organization_information.org_information1%type;
4496: l_low_limit_method hr_organization_information.org_information1%type;
4497: l_low_limit_amount NUMBER ;
4498: l_high_limit_method hr_organization_information.org_information1%type;

Line 4495: l_er_cont_base_method hr_organization_information.org_information1%type;

4491: l_message VARCHAR2(255);
4492: l_dimension VARCHAR2(10);
4493:
4494: l_ee_cont_base_method hr_organization_information.org_information1%type;
4495: l_er_cont_base_method hr_organization_information.org_information1%type;
4496: l_low_limit_method hr_organization_information.org_information1%type;
4497: l_low_limit_amount NUMBER ;
4498: l_high_limit_method hr_organization_information.org_information1%type;
4499: l_high_limit_amount NUMBER ;

Line 4496: l_low_limit_method hr_organization_information.org_information1%type;

4492: l_dimension VARCHAR2(10);
4493:
4494: l_ee_cont_base_method hr_organization_information.org_information1%type;
4495: l_er_cont_base_method hr_organization_information.org_information1%type;
4496: l_low_limit_method hr_organization_information.org_information1%type;
4497: l_low_limit_amount NUMBER ;
4498: l_high_limit_method hr_organization_information.org_information1%type;
4499: l_high_limit_amount NUMBER ;
4500: l_switch_periodicity hr_organization_information.org_information1%type;

Line 4498: l_high_limit_method hr_organization_information.org_information1%type;

4494: l_ee_cont_base_method hr_organization_information.org_information1%type;
4495: l_er_cont_base_method hr_organization_information.org_information1%type;
4496: l_low_limit_method hr_organization_information.org_information1%type;
4497: l_low_limit_amount NUMBER ;
4498: l_high_limit_method hr_organization_information.org_information1%type;
4499: l_high_limit_amount NUMBER ;
4500: l_switch_periodicity hr_organization_information.org_information1%type;
4501: l_switch_month hr_organization_information.org_information1%type;
4502: l_rounding_method hr_organization_information.org_information1%type;

Line 4500: l_switch_periodicity hr_organization_information.org_information1%type;

4496: l_low_limit_method hr_organization_information.org_information1%type;
4497: l_low_limit_amount NUMBER ;
4498: l_high_limit_method hr_organization_information.org_information1%type;
4499: l_high_limit_amount NUMBER ;
4500: l_switch_periodicity hr_organization_information.org_information1%type;
4501: l_switch_month hr_organization_information.org_information1%type;
4502: l_rounding_method hr_organization_information.org_information1%type;
4503: l_lowest_avg_salary NUMBER ;
4504: l_average_salary NUMBER ;

Line 4501: l_switch_month hr_organization_information.org_information1%type;

4497: l_low_limit_amount NUMBER ;
4498: l_high_limit_method hr_organization_information.org_information1%type;
4499: l_high_limit_amount NUMBER ;
4500: l_switch_periodicity hr_organization_information.org_information1%type;
4501: l_switch_month hr_organization_information.org_information1%type;
4502: l_rounding_method hr_organization_information.org_information1%type;
4503: l_lowest_avg_salary NUMBER ;
4504: l_average_salary NUMBER ;
4505: l_ee_fixed_amount NUMBER ;

Line 4502: l_rounding_method hr_organization_information.org_information1%type;

4498: l_high_limit_method hr_organization_information.org_information1%type;
4499: l_high_limit_amount NUMBER ;
4500: l_switch_periodicity hr_organization_information.org_information1%type;
4501: l_switch_month hr_organization_information.org_information1%type;
4502: l_rounding_method hr_organization_information.org_information1%type;
4503: l_lowest_avg_salary NUMBER ;
4504: l_average_salary NUMBER ;
4505: l_ee_fixed_amount NUMBER ;
4506: l_er_fixed_amount NUMBER ;

Line 4709: FROM hr_organization_information hoi

4705: CURSOR get_rule( p_date_earned DATE
4706: , p_tax_area VARCHAR2
4707: ) IS
4708: SELECT hoi.org_information2
4709: FROM hr_organization_information hoi
4710: WHERE hoi.org_information_context = 'PER_SEVERANCE_PAY_TAX_RULE_CN'
4711: AND hoi.org_information1 = p_tax_area
4712: AND hoi.organization_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
4713: AND p_date_earned BETWEEN to_date(substr(hoi.org_information3,1,10),'YYYY/MM/DD')

Line 4776: FROM hr_organization_information hoi

4772: SELECT hoi.org_information1,
4773: hoi.org_information2,
4774: hoi.org_information3,
4775: hoi.org_information4
4776: FROM hr_organization_information hoi
4777: WHERE hoi.org_information_context = 'PER_ENN_ANN_TAX_CN'
4778: AND hoi.org_information1 = p_tax_area
4779: AND hoi.organization_id = p_le;
4780:

Line 4785: FROM hr_organization_information hoi

4781: CURSOR get_rule_bg( p_date_paid DATE
4782: , p_tax_area VARCHAR2
4783: ) IS
4784: SELECT hoi.org_information2
4785: FROM hr_organization_information hoi
4786: WHERE hoi.org_information_context = 'PER_ENN_ANN_TAX_CN'
4787: AND hoi.org_information1 = p_tax_area
4788: AND hoi.organization_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
4789: AND p_date_paid BETWEEN fnd_date.canonical_to_date(hoi.org_information3)