DBA Data[Home] [Help]

APPS.PAY_SEED_UTL dependencies on PAY_DEFINED_BALANCES

Line 48: from pay_balance_types b, pay_balance_dimensions d, pay_defined_balances db

44: CURSOR c_defined_balance_id(p_balance_name VARCHAR2,
45: p_dimension VARCHAR2,
46: p_legislation_code VARCHAR2) IS
47: select db.defined_balance_id
48: from pay_balance_types b, pay_balance_dimensions d, pay_defined_balances db
49: where b.balance_name = p_balance_name
50: and d.dimension_name = p_dimension
51: and db.balance_type_id = b.balance_type_id
52: and db.balance_dimension_id = d.balance_dimension_id

Line 264: from pay_balance_types b, pay_balance_dimensions d, pay_defined_balances db

260: CURSOR c_defined_balance_id(p_balance_name VARCHAR2,
261: p_dimension VARCHAR2,
262: p_legislation_code VARCHAR2) IS
263: select db.defined_balance_id
264: from pay_balance_types b, pay_balance_dimensions d, pay_defined_balances db
265: where b.balance_name = p_balance_name
266: and d.dimension_name = p_dimension
267: and db.balance_type_id = b.balance_type_id
268: and db.balance_dimension_id = d.balance_dimension_id