DBA Data[Home] [Help]

APPS.PAY_KR_HIA_PKG dependencies on PAY_DEFINED_BALANCES

Line 28: g_dbl_id_hi_prem pay_defined_balances.defined_balance_id%type;

24: --
25: --Bug 2931128 . This global value stores defined balance id
26: --for defined balance HI_PREM_EE_WO_ADJ_ASG_MTD_MTH
27:
28: g_dbl_id_hi_prem pay_defined_balances.defined_balance_id%type;
29:
30: --------------------------------------------------------------------------------+
31: -- Range cursor returns the ids of the assignments to be archived
32: --------------------------------------------------------------------------------+

Line 325: pay_defined_balances pdb

321: is
322: select defined_balance_id
323: from pay_balance_types pbt ,
324: pay_balance_dimensions pbd ,
325: pay_defined_balances pdb
326: where pbt.balance_name =p_balance_name
327: and pbt.legislation_code ='KR'
328: and pbd.dimension_name =p_dimension_name
329: and pbd.legislation_code ='KR'