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_FR_ARC_PKG dependencies on PAY_BALANCE_CATEGORIES_F

Line 104: g_CSG_non_Deductible pay_balance_categories_f.balance_category_id%TYPE;

100: -- to hold the application_id of 'PER'
101: --
102: g_per_id fnd_application.application_id%TYPE;
103: --
104: g_CSG_non_Deductible pay_balance_categories_f.balance_category_id%TYPE;
105: g_Conv_EE_Deductions pay_balance_categories_f.balance_category_id%TYPE;
106: g_Conv_ER_Charges pay_balance_categories_f.balance_category_id%TYPE;
107: g_Income_Tax_Excess pay_balance_categories_f.balance_category_id%TYPE;
108: g_Rebates pay_balance_categories_f.balance_category_id%TYPE;

Line 105: g_Conv_EE_Deductions pay_balance_categories_f.balance_category_id%TYPE;

101: --
102: g_per_id fnd_application.application_id%TYPE;
103: --
104: g_CSG_non_Deductible pay_balance_categories_f.balance_category_id%TYPE;
105: g_Conv_EE_Deductions pay_balance_categories_f.balance_category_id%TYPE;
106: g_Conv_ER_Charges pay_balance_categories_f.balance_category_id%TYPE;
107: g_Income_Tax_Excess pay_balance_categories_f.balance_category_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;

Line 106: g_Conv_ER_Charges pay_balance_categories_f.balance_category_id%TYPE;

102: g_per_id fnd_application.application_id%TYPE;
103: --
104: g_CSG_non_Deductible pay_balance_categories_f.balance_category_id%TYPE;
105: g_Conv_EE_Deductions pay_balance_categories_f.balance_category_id%TYPE;
106: g_Conv_ER_Charges pay_balance_categories_f.balance_category_id%TYPE;
107: g_Income_Tax_Excess pay_balance_categories_f.balance_category_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;

Line 107: g_Income_Tax_Excess pay_balance_categories_f.balance_category_id%TYPE;

103: --
104: g_CSG_non_Deductible pay_balance_categories_f.balance_category_id%TYPE;
105: g_Conv_EE_Deductions pay_balance_categories_f.balance_category_id%TYPE;
106: g_Conv_ER_Charges pay_balance_categories_f.balance_category_id%TYPE;
107: g_Income_Tax_Excess pay_balance_categories_f.balance_category_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: --

Line 108: g_Rebates pay_balance_categories_f.balance_category_id%TYPE;

104: g_CSG_non_Deductible pay_balance_categories_f.balance_category_id%TYPE;
105: g_Conv_EE_Deductions pay_balance_categories_f.balance_category_id%TYPE;
106: g_Conv_ER_Charges pay_balance_categories_f.balance_category_id%TYPE;
107: g_Income_Tax_Excess pay_balance_categories_f.balance_category_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;

Line 109: g_Stat_EE_Deductions pay_balance_categories_f.balance_category_id%TYPE;

105: g_Conv_EE_Deductions pay_balance_categories_f.balance_category_id%TYPE;
106: g_Conv_ER_Charges pay_balance_categories_f.balance_category_id%TYPE;
107: g_Income_Tax_Excess pay_balance_categories_f.balance_category_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;

Line 110: g_Stat_ER_Charges pay_balance_categories_f.balance_category_id%TYPE;

106: g_Conv_ER_Charges pay_balance_categories_f.balance_category_id%TYPE;
107: g_Income_Tax_Excess pay_balance_categories_f.balance_category_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;

Line 297: from pay_balance_categories_f

293: --
294: -- get the balance category IDs
295: cursor csr_get_bal_cat (p_name varchar2) is
296: select balance_category_id
297: from pay_balance_categories_f
298: where legislation_code = 'FR'
299: and category_name = p_name
300: order by effective_start_date asc;
301: --