APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_BALANCE_TYPES

Line 44: -- g_abs_bal_type_id pay_balance_types.balance_type_id%type;

40: g_lon_rate_type pay_user_column_instances_f.value%type;
41: g_asg_emp_cat_cd per_all_assignments_f.employment_category%TYPE;
42: g_ext_emp_cat_cd per_all_assignments_f.employment_category%TYPE;
43: g_ext_emp_wrkp_cd per_all_assignments_f.employment_category%TYPE;
44: -- g_abs_bal_type_id pay_balance_types.balance_type_id%type;
45: -- g_sal_bal_type_id pay_balance_types.balance_type_id%type;
46: g_primary_assignment_id per_all_assignments_f.assignment_id%TYPE;
47: g_equal_sal_rate VARCHAR2(1);
48: -- Added for bugfix 3073562:GAP1:GAP2

Line 45: -- g_sal_bal_type_id pay_balance_types.balance_type_id%type;

41: g_asg_emp_cat_cd per_all_assignments_f.employment_category%TYPE;
42: g_ext_emp_cat_cd per_all_assignments_f.employment_category%TYPE;
43: g_ext_emp_wrkp_cd per_all_assignments_f.employment_category%TYPE;
44: -- g_abs_bal_type_id pay_balance_types.balance_type_id%type;
45: -- g_sal_bal_type_id pay_balance_types.balance_type_id%type;
46: g_primary_assignment_id per_all_assignments_f.assignment_id%TYPE;
47: g_equal_sal_rate VARCHAR2(1);
48: -- Added for bugfix 3073562:GAP1:GAP2
49: g_multiperson_mode VARCHAR2(1) := 'N';

Line 872: from pay_balance_types

868: (c_balance_name varchar2
869: ,c_business_group_id number
870: ) is
871: select balance_type_id, legislation_code -- 4336613 : added leg_code
872: from pay_balance_types
873: where balance_name = c_balance_name
874: and (
875: (business_group_id IS NOT NULL AND
876: business_group_id = NVL(c_business_group_id, g_business_group_id)