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 1050: FROM hr_organization_information

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

Line 1070: FROM hr_organization_information

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

Line 1090: FROM hr_organization_information

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

Line 1110: FROM hr_organization_information

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

Line 1176: FROM hr_organization_information

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

Line 3287: l_ee_cont_base_method hr_organization_information.org_information1%type;

3283: l_er_stat_percentage NUMBER;
3284:
3285: g_procedure_name VARCHAR2(50);
3286:
3287: l_ee_cont_base_method hr_organization_information.org_information1%type;
3288: l_er_cont_base_method hr_organization_information.org_information1%type;
3289: l_low_limit_method hr_organization_information.org_information1%type;
3290: l_high_limit_method hr_organization_information.org_information1%type;
3291: l_low_limit_amount NUMBER;

Line 3288: l_er_cont_base_method hr_organization_information.org_information1%type;

3284:
3285: g_procedure_name VARCHAR2(50);
3286:
3287: l_ee_cont_base_method hr_organization_information.org_information1%type;
3288: l_er_cont_base_method hr_organization_information.org_information1%type;
3289: l_low_limit_method hr_organization_information.org_information1%type;
3290: l_high_limit_method hr_organization_information.org_information1%type;
3291: l_low_limit_amount NUMBER;
3292: l_high_limit_amount NUMBER;

Line 3289: l_low_limit_method hr_organization_information.org_information1%type;

3285: g_procedure_name VARCHAR2(50);
3286:
3287: l_ee_cont_base_method hr_organization_information.org_information1%type;
3288: l_er_cont_base_method hr_organization_information.org_information1%type;
3289: l_low_limit_method hr_organization_information.org_information1%type;
3290: l_high_limit_method hr_organization_information.org_information1%type;
3291: l_low_limit_amount NUMBER;
3292: l_high_limit_amount NUMBER;
3293: l_tax_thrhld_amount NUMBER; -- for bug 6828199

Line 3290: l_high_limit_method hr_organization_information.org_information1%type;

3286:
3287: l_ee_cont_base_method hr_organization_information.org_information1%type;
3288: l_er_cont_base_method hr_organization_information.org_information1%type;
3289: l_low_limit_method hr_organization_information.org_information1%type;
3290: l_high_limit_method hr_organization_information.org_information1%type;
3291: l_low_limit_amount NUMBER;
3292: l_high_limit_amount NUMBER;
3293: l_tax_thrhld_amount NUMBER; -- for bug 6828199
3294: l_switch_periodicity hr_organization_information.org_information1%type;

Line 3294: l_switch_periodicity hr_organization_information.org_information1%type;

3290: l_high_limit_method hr_organization_information.org_information1%type;
3291: l_low_limit_amount NUMBER;
3292: l_high_limit_amount NUMBER;
3293: l_tax_thrhld_amount NUMBER; -- for bug 6828199
3294: l_switch_periodicity hr_organization_information.org_information1%type;
3295: l_switch_month hr_organization_information.org_information1%type;
3296: l_base_rounding_method hr_organization_information.org_information1%type;
3297: l_lowest_avg_salary NUMBER;
3298: l_average_salary NUMBER;

Line 3295: l_switch_month hr_organization_information.org_information1%type;

3291: l_low_limit_amount NUMBER;
3292: l_high_limit_amount NUMBER;
3293: l_tax_thrhld_amount NUMBER; -- for bug 6828199
3294: l_switch_periodicity hr_organization_information.org_information1%type;
3295: l_switch_month hr_organization_information.org_information1%type;
3296: l_base_rounding_method hr_organization_information.org_information1%type;
3297: l_lowest_avg_salary NUMBER;
3298: l_average_salary NUMBER;
3299: l_ee_fixed_amount NUMBER;

Line 3296: l_base_rounding_method hr_organization_information.org_information1%type;

3292: l_high_limit_amount NUMBER;
3293: l_tax_thrhld_amount NUMBER; -- for bug 6828199
3294: l_switch_periodicity hr_organization_information.org_information1%type;
3295: l_switch_month hr_organization_information.org_information1%type;
3296: l_base_rounding_method hr_organization_information.org_information1%type;
3297: l_lowest_avg_salary NUMBER;
3298: l_average_salary NUMBER;
3299: l_ee_fixed_amount NUMBER;
3300: l_er_fixed_amount NUMBER;

Line 3301: l_ee_rate_type hr_organization_information.org_information1%type;

3297: l_lowest_avg_salary NUMBER;
3298: l_average_salary NUMBER;
3299: l_ee_fixed_amount NUMBER;
3300: l_er_fixed_amount NUMBER;
3301: l_ee_rate_type hr_organization_information.org_information1%type;
3302: l_er_rate_type hr_organization_information.org_information1%type;
3303: l_ee_rate NUMBER;
3304: l_er_rate NUMBER;
3305: l_ee_thrhld_rate NUMBER; -- for bug 6828199

Line 3302: l_er_rate_type hr_organization_information.org_information1%type;

3298: l_average_salary NUMBER;
3299: l_ee_fixed_amount NUMBER;
3300: l_er_fixed_amount NUMBER;
3301: l_ee_rate_type hr_organization_information.org_information1%type;
3302: l_er_rate_type hr_organization_information.org_information1%type;
3303: l_ee_rate NUMBER;
3304: l_er_rate NUMBER;
3305: l_ee_thrhld_rate NUMBER; -- for bug 6828199
3306: l_er_thrhld_rate NUMBER; -- for bug 6828199

Line 3307: l_ee_rate_rounding_method hr_organization_information.org_information1%type;

3303: l_ee_rate NUMBER;
3304: l_er_rate NUMBER;
3305: l_ee_thrhld_rate NUMBER; -- for bug 6828199
3306: l_er_thrhld_rate NUMBER; -- for bug 6828199
3307: l_ee_rate_rounding_method hr_organization_information.org_information1%type;
3308: l_er_rate_rounding_method hr_organization_information.org_information1%type;
3309: l_defer_deductions hr_organization_information.org_information1%type;
3310: l_deduct_in_probation_expiry hr_organization_information.org_information1%type;
3311:

Line 3308: l_er_rate_rounding_method hr_organization_information.org_information1%type;

3304: l_er_rate NUMBER;
3305: l_ee_thrhld_rate NUMBER; -- for bug 6828199
3306: l_er_thrhld_rate NUMBER; -- for bug 6828199
3307: l_ee_rate_rounding_method hr_organization_information.org_information1%type;
3308: l_er_rate_rounding_method hr_organization_information.org_information1%type;
3309: l_defer_deductions hr_organization_information.org_information1%type;
3310: l_deduct_in_probation_expiry hr_organization_information.org_information1%type;
3311:
3312: l_message VARCHAR2(1000);

Line 3309: l_defer_deductions hr_organization_information.org_information1%type;

3305: l_ee_thrhld_rate NUMBER; -- for bug 6828199
3306: l_er_thrhld_rate NUMBER; -- for bug 6828199
3307: l_ee_rate_rounding_method hr_organization_information.org_information1%type;
3308: l_er_rate_rounding_method hr_organization_information.org_information1%type;
3309: l_defer_deductions hr_organization_information.org_information1%type;
3310: l_deduct_in_probation_expiry hr_organization_information.org_information1%type;
3311:
3312: l_message VARCHAR2(1000);
3313: l_recalculate_flag VARCHAR2(1);

Line 3310: l_deduct_in_probation_expiry hr_organization_information.org_information1%type;

3306: l_er_thrhld_rate NUMBER; -- for bug 6828199
3307: l_ee_rate_rounding_method hr_organization_information.org_information1%type;
3308: l_er_rate_rounding_method hr_organization_information.org_information1%type;
3309: l_defer_deductions hr_organization_information.org_information1%type;
3310: l_deduct_in_probation_expiry hr_organization_information.org_information1%type;
3311:
3312: l_message VARCHAR2(1000);
3313: l_recalculate_flag VARCHAR2(1);
3314: