DBA Data[Home] [Help]

APPS.PAY_DK_HOLIDAY_PAY_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 42: ,pay_balance_dimensions pbd

38: CURSOR get_dbal_id(p_balance_name VARCHAR2 , p_balance_dim VARCHAR2) IS
39: SELECT pdb.defined_balance_id
40: FROM pay_defined_balances pdb
41: ,pay_balance_types pbt
42: ,pay_balance_dimensions pbd
43: WHERE pbt.legislation_code='DK'
44: AND pbt.balance_name = p_balance_name
45: AND pbd.legislation_code = 'DK'
46: AND pbd.database_item_suffix = p_balance_dim