APPS.PAY_SG_CPFLINE dependencies on PAY_DEFINED_BALANCES

Line 31: type t_def_bal_id is table of pay_defined_balances.defined_balance_id%type ;

27: rec_action_info pay_action_information%rowtype ;
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 ;

Line 480: pay_defined_balances pdb,

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
484: and pdb.legislation_code = pbt.legislation_code