DBA Data[Home] [Help]

APPS.PAY_PAYMENT_XML_PKG dependencies on PAY_DEFINED_BALANCES

Line 536: , pay_defined_balances pdb

532: select nvl(pbt.reporting_name,pbt.balance_name),
533: pay_balance_pkg.get_value(pba.defined_balance_id,p_asg_act)
534: from pay_balance_attributes pba
535: , pay_bal_attribute_definitions pbad
536: , pay_defined_balances pdb
537: , pay_balance_types pbt
538: where pbad.attribute_name='PAYMENT_EARNINGS'
539: and pba.attribute_id=pbad.attribute_id
540: and (nvl(pba.legislation_code,'XXX')=p_leg_code

Line 552: , pay_defined_balances pdb

548: select nvl(pbt.reporting_name,pbt.balance_name),
549: pay_balance_pkg.get_value(pba.defined_balance_id,p_asg_act)
550: from pay_balance_attributes pba
551: , pay_bal_attribute_definitions pbad
552: , pay_defined_balances pdb
553: , pay_balance_types pbt
554: where pbad.attribute_name='PAYMENT_DEDUCTIONS'
555: and pba.attribute_id=pbad.attribute_id
556: and (nvl(pba.legislation_code,'XXX')=p_leg_code