DBA Data[Home] [Help]

APPS.PAY_DK_STATSR_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 183: ,pay_balance_dimensions pbd

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

Line 223: ,pay_balance_dimensions pbd

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