DBA Data[Home] [Help]

APPS.PAY_US_ARCHIVE dependencies on FF_DATABASE_ITEMS

Line 403: ff_database_items DI

399:
400: cursor csr_defined_balance is
401: select to_number(UE.creator_id)
402: from ff_user_entities UE,
403: ff_database_items DI
404: where DI.user_name = p_db_item_name
405: and UE.user_entity_id = DI.user_entity_id
406: and Ue.creator_type = 'B'
407: and UE.legislation_code = 'US';

Line 1811: from ff_database_items fdi,

1807: --hr_utility.trace('p_dbi_name is '||p_dbi_name);
1808:
1809: select fdi.user_entity_id
1810: into l_user_entity_id
1811: from ff_database_items fdi,
1812: ff_user_entities fue
1813: where fdi.user_name = p_dbi_name
1814: and fue.user_entity_id = fdi.user_entity_id
1815: and fue.legislation_code = 'US';