APPS.PQP_GB_PENSION_SCHEME_TEMPLATE dependencies on PAY_BALANCE_TYPES

Line 138: l_bal_name pay_balance_types.balance_name%TYPE;

134: INDEX BY BINARY_INTEGER;
135:
136: l_ele_name t_ele_name;
137: l_ele_new_name t_ele_name;
138: l_bal_name pay_balance_types.balance_name%TYPE;
139: l_bal_new_name pay_balance_types.balance_name%TYPE;
140: l_ele_class_name pay_element_classifications.classification_name%TYPE;
141: l_exc_ocp_rule_id VARCHAR2 (1);
142: l_exc_ers_cent_rule_id VARCHAR2 (1);

Line 139: l_bal_new_name pay_balance_types.balance_name%TYPE;

135:
136: l_ele_name t_ele_name;
137: l_ele_new_name t_ele_name;
138: l_bal_name pay_balance_types.balance_name%TYPE;
139: l_bal_new_name pay_balance_types.balance_name%TYPE;
140: l_ele_class_name pay_element_classifications.classification_name%TYPE;
141: l_exc_ocp_rule_id VARCHAR2 (1);
142: l_exc_ers_cent_rule_id VARCHAR2 (1);
143: l_exc_ers_fxd_rule_id VARCHAR2 (1);

Line 182: l_pensionable_sal_bal_name pay_balance_types.balance_name%TYPE;

178: l_iterative_priority pay_element_types_f.iterative_priority%TYPE;
179: l_iterative_formula ff_formulas_f.formula_name%TYPE;
180: l_sub_class_name pay_element_classifications.classification_name%TYPE;
181: l_pensionable_sal_bal_id NUMBER;
182: l_pensionable_sal_bal_name pay_balance_types.balance_name%TYPE;
183: l_arrearage_allowed VARCHAR2 (1)
184: := NVL (p_arrearage_allowed, 'N');
185: l_partial_deduction VARCHAR2 (1)
186: := NVL (p_partial_deduction, 'N');

Line 599: FROM pay_balance_types

595: -- Cursor to retrieve the balance information
596: CURSOR csr_get_bal_info
597: IS
598: SELECT balance_name
599: FROM pay_balance_types
600: WHERE balance_type_id = p_balance_type_id
601: AND ( ( business_group_id IS NOT NULL
602: AND business_group_id = p_business_group_id
603: )

Line 612: l_balance_name pay_balance_types.balance_name%TYPE;

608: );
609:
610: l_proc_name VARCHAR2 (80) := g_proc_name
611: || 'get_balance_info';
612: l_balance_name pay_balance_types.balance_name%TYPE;
613: --
614:
615: BEGIN
616: --