DBA Data[Home] [Help]

APPS.PAY_US_YEPP_ADD_ACTIONS_PKG dependencies on FF_DATABASE_ITEMS

Line 315: ff_database_items di

311: cursor csr_defined_balance
312: is
313: select to_number(ue.creator_id)
314: from ff_user_entities ue,
315: ff_database_items di
316: where di.user_name = p_db_item_name
317: and ue.user_entity_id = di.user_entity_id
318: and ue.creator_type = 'B'
319: and ue.legislation_code = 'US';

Line 461: from ff_database_items fdi,

457: cp_gre_id in number)
458: IS
459: Cursor c_get_dbi_id(cp_dbi_name in varchar2) is
460: select fdi.user_entity_id
461: from ff_database_items fdi,
462: ff_user_entities fue
463: where fdi.user_name = cp_dbi_name
464: and fue.user_entity_id = fdi.user_entity_id
465: and fue.legislation_code = 'US';