DBA Data[Home] [Help]

APPS.PAY_JP_ITWB_DML_PKG dependencies on PAY_DEFINED_BALANCES

Line 9135: from pay_defined_balances pdb,

9131: p_defined_balance_id in number)
9132: is
9133: select pbt.balance_name,
9134: pbd.database_item_suffix
9135: from pay_defined_balances pdb,
9136: pay_balance_types_vl pbt,
9137: pay_balance_dimensions_vl pbd
9138: where pdb.defined_balance_id = p_defined_balance_id
9139: and pbt.balance_type_id = pdb.balance_type_id

Line 9284: from pay_defined_balances pdb

9280: --
9281: cursor csr_dbal
9282: is
9283: select pdb.defined_balance_id
9284: from pay_defined_balances pdb
9285: where pdb.defined_balance_id = p_defined_balance_id
9286: and nvl(pdb.business_group_id,p_business_group_id) = p_business_group_id
9287: and nvl(pdb.legislation_code,c_legislation_code) = c_legislation_code
9288: and pdb.balance_type_id = p_balance_type_id;