108: g_Rebates pay_balance_categories_f.balance_category_id%TYPE;
109: g_Stat_EE_Deductions pay_balance_categories_f.balance_category_id%TYPE;
110: g_Stat_ER_Charges pay_balance_categories_f.balance_category_id%TYPE;
111: --
112: g_ele_class_CSG_non_Deductible pay_element_classifications.classification_id%TYPE;
113: g_ele_class_Conv_EE_Deductions pay_element_classifications.classification_id%TYPE;
114: g_ele_class_Conv_ER_Charges pay_element_classifications.classification_id%TYPE;
115: g_ele_class_Income_Tax_Excess pay_element_classifications.classification_id%TYPE;
116: g_ele_class_Rebates pay_element_classifications.classification_id%TYPE;
109: g_Stat_EE_Deductions pay_balance_categories_f.balance_category_id%TYPE;
110: g_Stat_ER_Charges pay_balance_categories_f.balance_category_id%TYPE;
111: --
112: g_ele_class_CSG_non_Deductible pay_element_classifications.classification_id%TYPE;
113: g_ele_class_Conv_EE_Deductions pay_element_classifications.classification_id%TYPE;
114: g_ele_class_Conv_ER_Charges pay_element_classifications.classification_id%TYPE;
115: g_ele_class_Income_Tax_Excess pay_element_classifications.classification_id%TYPE;
116: g_ele_class_Rebates pay_element_classifications.classification_id%TYPE;
117: g_ele_class_Stat_EE_Deductions pay_element_classifications.classification_id%TYPE;
110: g_Stat_ER_Charges pay_balance_categories_f.balance_category_id%TYPE;
111: --
112: g_ele_class_CSG_non_Deductible pay_element_classifications.classification_id%TYPE;
113: g_ele_class_Conv_EE_Deductions pay_element_classifications.classification_id%TYPE;
114: g_ele_class_Conv_ER_Charges pay_element_classifications.classification_id%TYPE;
115: g_ele_class_Income_Tax_Excess pay_element_classifications.classification_id%TYPE;
116: g_ele_class_Rebates pay_element_classifications.classification_id%TYPE;
117: g_ele_class_Stat_EE_Deductions pay_element_classifications.classification_id%TYPE;
118: g_ele_class_Stat_ER_Charges pay_element_classifications.classification_id%TYPE;
111: --
112: g_ele_class_CSG_non_Deductible pay_element_classifications.classification_id%TYPE;
113: g_ele_class_Conv_EE_Deductions pay_element_classifications.classification_id%TYPE;
114: g_ele_class_Conv_ER_Charges pay_element_classifications.classification_id%TYPE;
115: g_ele_class_Income_Tax_Excess pay_element_classifications.classification_id%TYPE;
116: g_ele_class_Rebates pay_element_classifications.classification_id%TYPE;
117: g_ele_class_Stat_EE_Deductions pay_element_classifications.classification_id%TYPE;
118: g_ele_class_Stat_ER_Charges pay_element_classifications.classification_id%TYPE;
119: g_ele_class_Net_EE_Deductions pay_element_classifications.classification_id%TYPE;
112: g_ele_class_CSG_non_Deductible pay_element_classifications.classification_id%TYPE;
113: g_ele_class_Conv_EE_Deductions pay_element_classifications.classification_id%TYPE;
114: g_ele_class_Conv_ER_Charges pay_element_classifications.classification_id%TYPE;
115: g_ele_class_Income_Tax_Excess pay_element_classifications.classification_id%TYPE;
116: g_ele_class_Rebates pay_element_classifications.classification_id%TYPE;
117: g_ele_class_Stat_EE_Deductions pay_element_classifications.classification_id%TYPE;
118: g_ele_class_Stat_ER_Charges pay_element_classifications.classification_id%TYPE;
119: g_ele_class_Net_EE_Deductions pay_element_classifications.classification_id%TYPE;
120: g_ele_class_ER_LV_Charges pay_element_classifications.classification_id%TYPE;
113: g_ele_class_Conv_EE_Deductions pay_element_classifications.classification_id%TYPE;
114: g_ele_class_Conv_ER_Charges pay_element_classifications.classification_id%TYPE;
115: g_ele_class_Income_Tax_Excess pay_element_classifications.classification_id%TYPE;
116: g_ele_class_Rebates pay_element_classifications.classification_id%TYPE;
117: g_ele_class_Stat_EE_Deductions pay_element_classifications.classification_id%TYPE;
118: g_ele_class_Stat_ER_Charges pay_element_classifications.classification_id%TYPE;
119: g_ele_class_Net_EE_Deductions pay_element_classifications.classification_id%TYPE;
120: g_ele_class_ER_LV_Charges pay_element_classifications.classification_id%TYPE;
121: --
114: g_ele_class_Conv_ER_Charges pay_element_classifications.classification_id%TYPE;
115: g_ele_class_Income_Tax_Excess pay_element_classifications.classification_id%TYPE;
116: g_ele_class_Rebates pay_element_classifications.classification_id%TYPE;
117: g_ele_class_Stat_EE_Deductions pay_element_classifications.classification_id%TYPE;
118: g_ele_class_Stat_ER_Charges pay_element_classifications.classification_id%TYPE;
119: g_ele_class_Net_EE_Deductions pay_element_classifications.classification_id%TYPE;
120: g_ele_class_ER_LV_Charges pay_element_classifications.classification_id%TYPE;
121: --
122: -- Globals added for security groups (bug 3683906)
115: g_ele_class_Income_Tax_Excess pay_element_classifications.classification_id%TYPE;
116: g_ele_class_Rebates pay_element_classifications.classification_id%TYPE;
117: g_ele_class_Stat_EE_Deductions pay_element_classifications.classification_id%TYPE;
118: g_ele_class_Stat_ER_Charges pay_element_classifications.classification_id%TYPE;
119: g_ele_class_Net_EE_Deductions pay_element_classifications.classification_id%TYPE;
120: g_ele_class_ER_LV_Charges pay_element_classifications.classification_id%TYPE;
121: --
122: -- Globals added for security groups (bug 3683906)
123: g_sec_grp_id_user_element_grp FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
116: g_ele_class_Rebates pay_element_classifications.classification_id%TYPE;
117: g_ele_class_Stat_EE_Deductions pay_element_classifications.classification_id%TYPE;
118: g_ele_class_Stat_ER_Charges pay_element_classifications.classification_id%TYPE;
119: g_ele_class_Net_EE_Deductions pay_element_classifications.classification_id%TYPE;
120: g_ele_class_ER_LV_Charges pay_element_classifications.classification_id%TYPE;
121: --
122: -- Globals added for security groups (bug 3683906)
123: g_sec_grp_id_user_element_grp FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
124: g_sec_grp_id_base_unit FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;
302: -- get the element_classification IDs
303: --
304: cursor csr_get_ele_class (p_name varchar2) is
305: select classification_id
306: from pay_element_classifications
307: where legislation_code = 'FR'
308: and classification_name = p_name;
309: --
310: l_proc VARCHAR2(40):= g_package||' archinit ';
2400: 'RR',rr_ret.end_date) retro_pro_end
2401: from pay_run_result_values prrv
2402: ,pay_run_results prr
2403: ,pay_element_types_f pet
2404: ,pay_element_classifications pec
2405: ,pay_input_values_f_tl piv
2406: ,fnd_lookup_values user_rubric
2407: ,fnd_lookup_values seed_rubric
2408: ,fnd_lookup_values base_units