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 609: pay_balance_types pbt,

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

Line 796: from pay_balance_types pbt,

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

Line 812: from pay_balance_types pbt,

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