APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_BALANCE_TYPES

Line 1924: l_bal_type_id pay_balance_types.balance_type_id%type;

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

Line 2184: l_bal_type_id pay_balance_types.balance_type_id%type;

2180: --
2181: l_proc_name varchar2(60) := g_proc_name || 'fetch_eles_for_t1_bals';
2182:
2183: l_tab_bal_name t_varchar;
2184: l_bal_type_id pay_balance_types.balance_type_id%type;
2185: i number;
2186:
2187: --
2188: begin

Line 9906: l_absence_bal_name pay_balance_types.balance_name%type;

9902: )
9903: return number is
9904: --
9905: l_proc_name varchar2(60) := g_proc_name || 'get_ft_days_excluded';
9906: l_absence_bal_name pay_balance_types.balance_name%type;
9907: l_days_excluded number;
9908: l_part_time_sal number;
9909: l_eff_start_date date ;
9910: l_eff_end_date date ;