APPS.PAY_US_ARCHIVE dependencies on FF_DATABASE_ITEMS

Line 371: ff_database_items DI

367:
368: cursor csr_defined_balance is
369: select to_number(UE.creator_id)
370: from ff_user_entities UE,
371: ff_database_items DI
372: where DI.user_name = p_db_item_name
373: and UE.user_entity_id = DI.user_entity_id
374: and Ue.creator_type = 'B'
375: and UE.legislation_code = 'US';

Line 1507: from ff_database_items fdi,

1503: --hr_utility.trace('p_dbi_name is '||p_dbi_name);
1504:
1505: select fdi.user_entity_id
1506: into l_user_entity_id
1507: from ff_database_items fdi,
1508: ff_user_entities fue
1509: where fdi.user_name = p_dbi_name
1510: and fue.user_entity_id = fdi.user_entity_id
1511: and fue.legislation_code = 'US';