DBA Data[Home] [Help]

APPS.PAY_DK_STATSR_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 184: ,pay_balance_dimensions pbd

180: CURSOR get_dbal_id(p_balance_name VARCHAR2 , p_balance_dim VARCHAR2) IS
181: SELECT pdb.defined_balance_id
182: FROM pay_defined_balances pdb
183: ,pay_balance_types pbt
184: ,pay_balance_dimensions pbd
185: WHERE pbt.legislation_code='DK'
186: AND pbt.balance_name = p_balance_name
187: AND pbd.legislation_code = 'DK'
188: AND pbd.database_item_suffix = p_balance_dim

Line 224: ,pay_balance_dimensions pbd

220: CURSOR get_dbal_id(p_balance_cat_name VARCHAR2 , p_balance_dim VARCHAR2) IS
221: SELECT pdb.defined_balance_id DBAL_ID
222: FROM pay_defined_balances pdb
223: ,pay_balance_types pbt
224: ,pay_balance_dimensions pbd
225: ,pay_balance_categories_f pbc
226: WHERE pbc.category_name = p_balance_cat_name
227: AND pbt.balance_category_id = pbc.balance_category_id
228: AND pbd.legislation_code = 'DK'