APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_BALANCE_TYPES

Line 1923: l_bal_type_id pay_balance_types.balance_type_id%type;

1919: --
1920: l_proc_name varchar2(60) := g_proc_name || 'fetch_eles_from_bals';
1921:
1922: l_tab_bal_name t_varchar;
1923: l_bal_type_id pay_balance_types.balance_type_id%type;
1924: l_legislation_code VARCHAR2(30); -- to hold legislation code of balance
1925: l_error NUMBER ;
1926: l_seed_flag VARCHAR2(1); -- flag to signify if balance is seeded/user defined
1927: --

Line 2211: l_bal_type_id pay_balance_types.balance_type_id%type;

2207: --
2208: l_proc_name varchar2(60) := g_proc_name || 'fetch_eles_for_t1_bals';
2209:
2210: l_tab_bal_name t_varchar;
2211: l_bal_type_id pay_balance_types.balance_type_id%type;
2212: i number;
2213:
2214: --
2215: begin

Line 10026: l_absence_bal_name pay_balance_types.balance_name%type;

10022: )
10023: return number is
10024: --
10025: l_proc_name varchar2(60) := g_proc_name || 'get_ft_days_excluded';
10026: l_absence_bal_name pay_balance_types.balance_name%type;
10027: l_days_excluded number;
10028: l_part_time_sal number;
10029: l_eff_start_date date ;
10030: l_eff_end_date date ;