DBA Data[Home] [Help]

APPS.PAY_SE_ARCHIVE_CWCA dependencies on PAY_BALANCE_DIMENSIONS

Line 1338: ,pay_balance_dimensions pbd

1334: CURSOR get_dbal_id(p_balance_name VARCHAR2 , p_balance_dim VARCHAR2) IS
1335: SELECT pdb.defined_balance_id
1336: FROM pay_defined_balances pdb
1337: ,pay_balance_types pbt
1338: ,pay_balance_dimensions pbd
1339: WHERE pbt.legislation_code='SE'
1340: AND pbt.balance_name = p_balance_name
1341: AND pbd.legislation_code = 'SE'
1342: AND pbd.database_item_suffix = p_balance_dim