DBA Data[Home] [Help]

APPS.PAY_EMP_ACTION_ARCH dependencies on PAY_DEFINED_BALANCES

Line 257: from pay_defined_balances pdb,

253: cursor c_get_defined_balance_id(cp_balance_id in number
254: ,cp_bal_dim in varchar2
255: ,cp_legislation_code in varchar2 ) is
256: select pdb.defined_balance_id
257: from pay_defined_balances pdb,
258: pay_balance_dimensions pbd
259: where pdb.balance_type_id = cp_balance_id
260: and pbd.database_item_suffix = cp_bal_dim
261: and pbd.balance_dimension_id = pdb.balance_dimension_id

Line 842: from pay_defined_balances pdb,

838: pbt.balance_name,
839: substr(pbd.database_item_suffix,2),
840: pbt.balance_uom,
841: nvl(pbtl.reporting_name,pbtl.balance_name)
842: from pay_defined_balances pdb,
843: pay_balance_dimensions pbd,
844: pay_balance_types pbt,
845: pay_balance_types_tl pbtl
846: where pbt.balance_type_id = cp_balance_type_id