DBA Data[Home] [Help]

APPS.PAY_EMP_ACTION_ARCH dependencies on PAY_DEFINED_BALANCES

Line 221: from pay_defined_balances pdb,

217: cursor c_get_defined_balance_id(cp_balance_id in number
218: ,cp_bal_dim in varchar2
219: ,cp_legislation_code in varchar2 ) is
220: select pdb.defined_balance_id
221: from pay_defined_balances pdb,
222: pay_balance_dimensions pbd
223: where pdb.balance_type_id = cp_balance_id
224: and pbd.database_item_suffix = cp_bal_dim
225: and pbd.balance_dimension_id = pdb.balance_dimension_id

Line 796: from pay_defined_balances pdb,

792: select pdb.defined_balance_id,
793: pbt.balance_name,
794: substr(pbd.database_item_suffix,2),
795: pbt.balance_uom
796: from pay_defined_balances pdb,
797: pay_balance_dimensions pbd,
798: pay_balance_types pbt
799: where pbt.balance_type_id = cp_balance_type_id
800: and pbd.balance_dimension_id = cp_balance_dimension_id