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.PQP_US_PENSION_EXTRACTS dependencies on PAY_BALANCE_TYPES

Line 100: FROM pay_balance_types pbt

96: CURSOR csr_defined_bal (c_balance_name IN VARCHAR2
97: ,c_dimension_name IN VARCHAR2
98: ,c_business_group_id IN NUMBER) IS
99: SELECT db.defined_balance_id
100: FROM pay_balance_types pbt
101: ,pay_defined_balances db
102: ,pay_balance_dimensions bd
103: WHERE pbt.balance_name = c_balance_name
104: AND pbt.balance_type_id = db.balance_type_id

Line 257: FROM pay_balance_types pbt

253: CURSOR csr_bal_typid (c_balance_name IN VARCHAR2
254: ,c_business_group_id IN NUMBER
255: ,c_legislation_code IN VARCHAR2) IS
256: SELECT pbt.balance_type_id
257: FROM pay_balance_types pbt
258: WHERE pbt.balance_name = c_balance_name
259: AND (pbt.business_group_id = c_business_group_id
260: OR
261: pbt.legislation_code = c_legislation_code);

Line 352: FROM pay_balance_types pbt

348: -- Cursor to get the balance name based on the balance type id
349: -- =============================================================================
350: CURSOR csr_bal_name (c_balance_type_id IN NUMBER) IS
351: SELECT pbt.balance_name
352: FROM pay_balance_types pbt
353: WHERE pbt.balance_type_id = c_balance_type_id;
354: -- =============================================================================
355: -- Cursor to check if there are any change events within the given date range
356: -- =============================================================================

Line 1329: l_balance_name pay_balance_types.balance_name%TYPE;

1325: l_input_name pay_input_values_f.NAME%TYPE;
1326: l_input_value_id pay_input_values_f.input_value_id%TYPE;
1327: l_element_name pay_element_types_f.element_name%TYPE;
1328: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
1329: l_balance_name pay_balance_types.balance_name%TYPE;
1330: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
1331: l_legislation_code per_business_groups.legislation_code%TYPE;
1332: l_info_category pay_element_types_f.element_information_category%TYPE;
1333: l_pretax_category pay_element_types_f.element_information1%TYPE;

Line 1330: l_balance_type_id pay_balance_types.balance_type_id%TYPE;

1326: l_input_value_id pay_input_values_f.input_value_id%TYPE;
1327: l_element_name pay_element_types_f.element_name%TYPE;
1328: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
1329: l_balance_name pay_balance_types.balance_name%TYPE;
1330: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
1331: l_legislation_code per_business_groups.legislation_code%TYPE;
1332: l_info_category pay_element_types_f.element_information_category%TYPE;
1333: l_pretax_category pay_element_types_f.element_information1%TYPE;
1334: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Element_Info';

Line 1603: l_balance_name pay_balance_types.balance_name%TYPE;

1599: l_input_name pay_input_values_f.NAME%TYPE;
1600: l_input_value_id pay_input_values_f.input_value_id%TYPE;
1601: l_element_name pay_element_types_f.element_name%TYPE;
1602: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
1603: l_balance_name pay_balance_types.balance_name%TYPE;
1604: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
1605: l_legislation_code per_business_groups.legislation_code%TYPE;
1606: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Element_Info';
1607: l_ele_info_rec csr_ele_info%ROWTYPE;

Line 1604: l_balance_type_id pay_balance_types.balance_type_id%TYPE;

1600: l_input_value_id pay_input_values_f.input_value_id%TYPE;
1601: l_element_name pay_element_types_f.element_name%TYPE;
1602: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
1603: l_balance_name pay_balance_types.balance_name%TYPE;
1604: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
1605: l_legislation_code per_business_groups.legislation_code%TYPE;
1606: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Element_Info';
1607: l_ele_info_rec csr_ele_info%ROWTYPE;
1608: BEGIN

Line 4064: l_balance_type_id pay_balance_types.balance_type_id%TYPE;

4060: ,p_ele_type_id IN NUMBER
4061: ,p_error_message OUT NOCOPY VARCHAR2
4062: ) RETURN NUMBER IS
4063:
4064: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
4065: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Balance_Id';
4066: BEGIN
4067: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
4068:

Line 4148: l_balance_type_id pay_balance_types.balance_type_id%TYPE;

4144: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
4145: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
4146: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
4147: l_legislation_code per_business_groups.legislation_code%TYPE;
4148: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
4149: i per_all_assignments_f.business_group_id%TYPE;
4150: l_valid_action VARCHAR2(2);
4151: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Deduction_Amount';
4152: BEGIN

Line 4426: l_balance_type_id pay_balance_types.balance_type_id%TYPE;

4422: l_bal_total_amt NUMBER :=0;
4423: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
4424: i per_all_assignments_f.business_group_id%TYPE;
4425: l_legislation_code per_business_groups.legislation_code%TYPE;
4426: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
4427: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
4428: l_new_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
4429: l_index NUMBER;
4430: l_assignment_action_id pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE;

Line 4677: l_balance_type_id pay_balance_types.balance_type_id%TYPE;

4673: l_bal_total_amt NUMBER :=0;
4674: l_dimension_name VARCHAR2(100);
4675: i per_all_assignments_f.business_group_id%TYPE;
4676: l_legislation_code per_business_groups.legislation_code%TYPE;
4677: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
4678: l_index NUMBER;
4679: BEGIN
4680: i := p_business_group_id;
4681: Hr_Utility.set_location('Entering Get_Balance_Value function:', 5);