APPS.PAY_SG_CPFLINE dependencies on PAY_BALANCE_TYPES

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

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

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

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

Line 479: from pay_balance_types pbt,

475: -- Bug 3595103 - Added new balance S Pass Liability
476: -------------------------------------------
477: select pdb.defined_balance_id,pbt.balance_name
478: bulk collect into g_def_bal_id , g_def_bal_name
479: from pay_balance_types pbt,
480: pay_defined_balances pdb,
481: pay_balance_dimensions pbd
482: where pbt.legislation_code = 'SG'
483: and pbd.legislation_code = pbt.legislation_code