DBA Data[Home] [Help]

APPS.PAY_NO_EOY_ARCHIVE dependencies on PAY_BALANCE_DIMENSIONS

Line 740: ,pay_balance_dimensions bd

736: ,p_balance_name IN VARCHAR2
737: ,p_database_item_suffix IN VARCHAR) IS
738: SELECT db.defined_balance_id
739: FROM pay_defined_balances db
740: ,pay_balance_dimensions bd
741: ,pay_balance_types bt
742: WHERE bt.balance_name = p_balance_name
743: AND ((bt.business_group_id IS NULL AND bt.legislation_code = 'NO') OR (bt.legislation_code IS NULL AND bt.business_group_id = p_business_group_id))
744: AND bd.database_item_suffix = p_database_item_suffix