APPS.PAY_SG_AWCAP_ARCHIVE dependencies on PAY_BALANCE_TYPES

Line 45: type t_bal_name_tbl is table of pay_balance_types.balance_name%type;

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;
46: g_bal_name_tbl t_bal_name_tbl;
47: -------------------------------------------------------------------
48: -- YTD balances Archival Variables
49: -------------------------------------------------------------------

Line 606: pay_balance_types pbt,

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
610: and pbt.balance_type_id = pdb.balance_type_id

Line 767: from pay_balance_types pbt,

763: pbt.balance_name
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

Line 783: from pay_balance_types pbt,

779: --
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