APPS.PAY_SG_CPFLINE dependencies on PAY_DEFINED_BALANCES

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

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

Line 645: pay_defined_balances pdb,

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