DBA Data[Home] [Help]

APPS.PAY_NO_EOY_ARCHIVE dependencies on PAY_BALANCE_DIMENSIONS

Line 833: ,pay_balance_dimensions bd

829: ,p_balance_name IN VARCHAR2
830: ,p_database_item_suffix IN VARCHAR) IS
831: SELECT db.defined_balance_id
832: FROM pay_defined_balances db
833: ,pay_balance_dimensions bd
834: ,pay_balance_types bt
835: WHERE bt.balance_name = p_balance_name
836: 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))
837: AND bd.database_item_suffix = p_database_item_suffix