APPS.PAY_SG_CPFLINE dependencies on PAY_BALANCE_TYPES

Line 33: type t_def_bal_name is table of pay_balance_types.balance_name%type ;

29: -----------------------------------------------------
30: -- Table to store Defined Balance details
31: -----------------------------------------------------
32: type t_def_bal_id is table of pay_defined_balances.defined_balance_id%type ;
33: type t_def_bal_name is table of pay_balance_types.balance_name%type ;
34: --
35: g_def_bal_id t_def_bal_id ;
36: g_def_bal_name t_def_bal_name ;
37: ----------------------------------------------------------------

Line 41: ( p_def_bal_name in pay_balance_types.balance_name%type ) return number

37: ----------------------------------------------------------------
38: -- Function Returns Defined Balance id
39: ----------------------------------------------------------------
40: function get_def_bal_id
41: ( p_def_bal_name in pay_balance_types.balance_name%type ) return number
42: is
43: begin
44: for i in 1..g_def_bal_name.count
45: loop

Line 644: from pay_balance_types pbt,

640: -- Bug 3595103 - Added new balance S Pass Liability
641: -------------------------------------------
642: select pdb.defined_balance_id,pbt.balance_name
643: bulk collect into g_def_bal_id , g_def_bal_name
644: from pay_balance_types pbt,
645: pay_defined_balances pdb,
646: pay_balance_dimensions pbd
647: where pbt.legislation_code = 'SG'
648: and pbd.legislation_code = pbt.legislation_code