DBA Data[Home] [Help]

APPS.PAY_FR_ARC_PKG dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 112: g_ele_class_CSG_non_Deductible pay_element_classifications.classification_id%TYPE;

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;

Line 113: g_ele_class_Conv_EE_Deductions 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;

Line 114: g_ele_class_Conv_ER_Charges 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;

Line 115: g_ele_class_Income_Tax_Excess 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;

Line 116: g_ele_class_Rebates 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;

Line 117: g_ele_class_Stat_EE_Deductions 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: --

Line 118: g_ele_class_Stat_ER_Charges 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: --
122: -- Globals added for security groups (bug 3683906)

Line 119: g_ele_class_Net_EE_Deductions 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)
123: g_sec_grp_id_user_element_grp FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;

Line 120: g_ele_class_ER_LV_Charges 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;
124: g_sec_grp_id_base_unit FND_LOOKUP_VALUES.SECURITY_GROUP_ID%TYPE;

Line 306: from pay_element_classifications

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 ';

Line 2404: ,pay_element_classifications pec

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