DBA Data[Home] [Help]

APPS.PAY_EMP_ACTION_ARCH dependencies on PAY_BALANCE_DIMENSIONS

Line 258: pay_balance_dimensions pbd

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
262: and ((pbd.legislation_code = cp_legislation_code and

Line 843: pay_balance_dimensions pbd,

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
847: and pbd.balance_dimension_id = cp_balance_dimension_id