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 603: FROM pay_balance_types

599: -- Cursor to retrieve the balance information
600: CURSOR csr_get_bal_info
601: IS
602: SELECT balance_name
603: FROM pay_balance_types
604: WHERE balance_type_id = p_balance_type_id
605: AND ( ( business_group_id IS NOT NULL
606: AND business_group_id = p_business_group_id
607: )

Line 616: l_balance_name pay_balance_types.balance_name%TYPE;

612: );
613:
614: l_proc_name VARCHAR2 (80) := g_proc_name
615: || 'get_balance_info';
616: l_balance_name pay_balance_types.balance_name%TYPE;
617: --
618:
619: BEGIN
620: --