DBA Data[Home] [Help]

APPS.PAY_SE_ARCHIVE_CWCA dependencies on PAY_DEFINED_BALANCES

Line 1330: l_context1 PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;

1326: ,p_balance_name IN VARCHAR2
1327: ,p_balance_dim IN VARCHAR2
1328: ,p_virtual_date IN DATE) RETURN NUMBER IS
1329:
1330: l_context1 PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
1331: l_value NUMBER;
1332:
1333:
1334: CURSOR get_dbal_id(p_balance_name VARCHAR2 , p_balance_dim VARCHAR2) IS

Line 1336: FROM pay_defined_balances pdb

1332:
1333:
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