DBA Data[Home] [Help]

APPS.PAY_CN_PAYSLIP dependencies on PAY_BALANCE_PKG

Line 52: SELECT nvl(pay_balance_pkg.get_value(pdb.defined_balance_id,p_assignment_action_id),0)

48: (
49: p_dimension_name VARCHAR2
50: )
51: IS
52: SELECT nvl(pay_balance_pkg.get_value(pdb.defined_balance_id,p_assignment_action_id),0)
53: FROM pay_balance_dimensions pbd
54: ,pay_defined_balances pdb
55: ,pay_balance_types pbt
56: WHERE pbt.balance_name = p_balance_name