APPS.PAY_SG_SOE dependencies on PAY_DEFINED_BALANCES

Line 148: pay_defined_balances pdb,

144: c_balance_name pay_balance_types.balance_name%type,
145: c_dimension_name pay_balance_dimensions.dimension_name%type) is
146: select nvl(pay_balance_pkg.get_value(pdb.defined_balance_id,c_assignment_action_id),0)
147: from pay_balance_dimensions pbd,
148: pay_defined_balances pdb,
149: pay_balance_types pbt
150: where pbt.balance_name = c_balance_name
151: and pbd.dimension_name = c_dimension_name
152: and pbt.balance_type_id = pdb.balance_type_id

Line 382: pay_defined_balances pdb,

378: c_balance_name pay_balance_types.balance_name%type,
379: c_dimension_name pay_balance_dimensions.dimension_name%type) is
380: select nvl(pay_balance_pkg.get_value(pdb.defined_balance_id,c_assignment_action_id),0)
381: from pay_balance_dimensions pbd,
382: pay_defined_balances pdb,
383: pay_balance_types pbt
384: where pbt.balance_name = c_balance_name
385: and pbd.dimension_name = c_dimension_name
386: and pbt.balance_type_id = pdb.balance_type_id