APPS.PAY_SG_AWCAP_ARCHIVE dependencies on PAY_DEFINED_BALANCES

Line 41: type t_def_bal_tbl is table of pay_defined_balances.defined_balance_id%type;

37: --
38: -----------------------------------------------------
39: -- Table to store Defined Balance details
40: -----------------------------------------------------
41: type t_def_bal_tbl is table of pay_defined_balances.defined_balance_id%type;
42: g_ytd_def_bal_tbl t_def_bal_tbl;
43: g_mtd_def_bal_tbl t_def_bal_tbl;
44: --
45: type t_bal_name_tbl is table of pay_balance_types.balance_name%type;

Line 605: from pay_defined_balances pdb,

601: cursor c_defined_bal_id ( p_balance_name in varchar2,
602: p_dimension_name in varchar2 )
603: is
604: select pdb.defined_balance_id
605: from pay_defined_balances pdb,
606: pay_balance_types pbt,
607: pay_balance_dimensions pbd
608: where pbt.balance_name = p_balance_name
609: and pbd.dimension_name = p_dimension_name

Line 768: pay_defined_balances pdb,

764: bulk collect into
765: g_ytd_def_bal_tbl,
766: g_bal_name_tbl
767: from pay_balance_types pbt,
768: pay_defined_balances pdb,
769: pay_balance_dimensions pbd
770: where pbt.legislation_code = 'SG'
771: and pbd.legislation_code = pbt.legislation_code
772: and pdb.legislation_code = pbt.legislation_code

Line 784: pay_defined_balances pdb,

780: select pdb.defined_balance_id def_bal_id
781: bulk collect into
782: g_mtd_def_bal_tbl
783: from pay_balance_types pbt,
784: pay_defined_balances pdb,
785: pay_balance_dimensions pbd
786: where pbt.legislation_code = 'SG'
787: and pbd.legislation_code = pbt.legislation_code
788: and pdb.legislation_code = pbt.legislation_code