DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_PSTA dependencies on PAY_DEFINED_BALANCES

Line 1812: from pay_balance_types pbt, pay_balance_dimensions pbd, pay_defined_balances pdb

1808: cursor csr_get_defined_balance_id (
1809: csr_v_balance_name ff_database_items.user_name%type
1810: ) is
1811: select defined_balance_id
1812: from pay_balance_types pbt, pay_balance_dimensions pbd, pay_defined_balances pdb
1813: where pbt.balance_name = csr_v_balance_name
1814: and nvl(pbt.business_group_id,g_business_group_id) = g_business_group_id
1815: and pbt.balance_type_id = pdb.balance_type_id
1816: and pbd.database_item_suffix = p_database_item_suffix --'_PER_YTD'