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 608: from pay_defined_balances pdb,

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

Line 797: pay_defined_balances pdb,

793: bulk collect into
794: g_ytd_def_bal_tbl,
795: g_bal_name_tbl
796: from pay_balance_types pbt,
797: pay_defined_balances pdb,
798: pay_balance_dimensions pbd
799: where pbt.legislation_code = 'SG'
800: and pbd.legislation_code = pbt.legislation_code
801: and pdb.legislation_code = pbt.legislation_code

Line 813: pay_defined_balances pdb,

809: select pdb.defined_balance_id def_bal_id
810: bulk collect into
811: g_mtd_def_bal_tbl
812: from pay_balance_types pbt,
813: pay_defined_balances pdb,
814: pay_balance_dimensions pbd
815: where pbt.legislation_code = 'SG'
816: and pbd.legislation_code = pbt.legislation_code
817: and pdb.legislation_code = pbt.legislation_code