DBA Data[Home] [Help]

APPS.PAY_SE_SLSA_ARCHIVE dependencies on PAY_BALANCE_DIMENSIONS

Line 413: FROM pay_balance_types pbt, pay_balance_dimensions pbd, pay_defined_balances pdb

409: CURSOR csr_get_defined_balance_id (
410: csr_v_balance_name ff_database_items.user_name%TYPE
411: ) IS
412: SELECT defined_balance_id
413: FROM pay_balance_types pbt, pay_balance_dimensions pbd, pay_defined_balances pdb
414: WHERE pbt.balance_name = csr_v_balance_name
415: AND nvl (pbt.business_group_id, g_business_group_id) = g_business_group_id
416: AND pbt.balance_type_id = pdb.balance_type_id
417: AND pbd.database_item_suffix = '_ASG_YTD'