APPS.PAY_SEED_UTL dependencies on PAY_BALANCE_DIMENSIONS

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 239: from pay_balance_dimensions

235: -- Cursor to retrieve balance_dimension_id given name
236: CURSOR c_dimension_name_id(p_dimension_name VARCHAR2,
237: p_legislation_code VARCHAR2) IS
238: select balance_dimension_id
239: from pay_balance_dimensions
240: where dimension_name = p_dimension_name
241: and (legislation_code = p_legislation_code or
242: ( legislation_code is null and p_legislation_code is null ))
243: and business_group_id IS NULL;

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