APPS.PQP_PENSION_EXTRACTS dependencies on PAY_BALANCE_TYPES

Line 290: FROM pay_balance_types pbt

286: CURSOR csr_bal_typid (c_balance_name IN VARCHAR2
287: ,c_business_group_id IN NUMBER
288: ,c_legislation_code IN VARCHAR2) IS
289: SELECT pbt.balance_type_id
290: FROM pay_balance_types pbt
291: WHERE pbt.balance_name = c_balance_name
292: AND (pbt.business_group_id = c_business_group_id
293: OR
294: pbt.legislation_code = c_legislation_code);

Line 795: FROM pay_balance_types pbt

791:
792: -- Cursor to get the balance_type_id for a given balance name
793: CURSOR csr_bal_name (c_balance_type_id IN NUMBER) IS
794: SELECT pbt.balance_name
795: FROM pay_balance_types pbt
796: WHERE pbt.balance_type_id = c_balance_type_id;
797:
798: l_input_name pay_input_values_f.NAME%TYPE :='Pay Value';
799: l_input_value_id pay_input_values_f.input_value_id%TYPE;

Line 802: l_balance_name pay_balance_types.balance_name%TYPE;

798: l_input_name pay_input_values_f.NAME%TYPE :='Pay Value';
799: l_input_value_id pay_input_values_f.input_value_id%TYPE;
800: l_element_name pay_element_types_f.element_name%TYPE;
801: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
802: l_balance_name pay_balance_types.balance_name%TYPE;
803: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
804: l_legislation_code per_business_groups.legislation_code%TYPE;
805: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Element_Info';
806: l_ele_info_rec csr_ele_info%ROWTYPE;

Line 803: l_balance_type_id pay_balance_types.balance_type_id%TYPE;

799: l_input_value_id pay_input_values_f.input_value_id%TYPE;
800: l_element_name pay_element_types_f.element_name%TYPE;
801: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
802: l_balance_name pay_balance_types.balance_name%TYPE;
803: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
804: l_legislation_code per_business_groups.legislation_code%TYPE;
805: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Element_Info';
806: l_ele_info_rec csr_ele_info%ROWTYPE;
807:

Line 3479: l_balance_type_id pay_balance_types.balance_type_id%TYPE;

3475: l_bal_total_amt NUMBER :=0;
3476: l_dimension_name VARCHAR2(100);
3477: i per_all_assignments_f.business_group_id%TYPE;
3478: l_legislation_code per_business_groups.legislation_code%TYPE;
3479: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
3480: l_index NUMBER;
3481: l_valid_person_chk VARCHAR2(2);
3482: l_organization_id NUMBER(15);
3483: l_gre_org_id NUMBER(15);