DBA Data[Home] [Help]

APPS.PAY_US_SQWL_ARCHIVE dependencies on FF_DATABASE_ITEMS

Line 347: ff_database_items DI

343:
344: cursor csr_defined_balance is
345: select fnd_number.canonical_to_number(UE.creator_id)
346: from ff_user_entities UE,
347: ff_database_items DI
348: where DI.user_name = p_db_item_name
349: and UE.user_entity_id = DI.user_entity_id
350: and Ue.creator_type = 'B'
351: and UE.legislation_code = 'US';

Line 725: from ff_database_items

721: begin
722:
723: select user_entity_id
724: into l_user_entity_id
725: from ff_database_items
726: where user_name = p_dbi_name;
727:
728: return l_user_entity_id;
729:

Line 3325: from ff_database_items

3321: update ff_archive_items ffai
3322: set ffai.value = 0
3323: where ffai.user_entity_id in (
3324: select user_entity_id
3325: from ff_database_items
3326: where user_name in ('A_SUI_ER_SUBJ_WHABLE_PER_JD_GRE_QTD',
3327: 'A_SUI_ER_SUBJ_NWHABLE_PER_JD_GRE_QTD',
3328: 'A_SUI_ER_125_REDNS_PER_JD_GRE_QTD',
3329: 'A_SUI_ER_401_REDNS_PER_JD_GRE_QTD',