DBA Data[Home] [Help]

APPS.PAY_US_SQWL_ARCHIVE dependencies on FF_DATABASE_ITEMS

Line 292: ff_database_items DI

288:
289: cursor csr_defined_balance is
290: select fnd_number.canonical_to_number(UE.creator_id)
291: from ff_user_entities UE,
292: ff_database_items DI
293: where DI.user_name = p_db_item_name
294: and UE.user_entity_id = DI.user_entity_id
295: and Ue.creator_type = 'B'
296: and UE.legislation_code = 'US';

Line 656: from ff_database_items

652: begin
653:
654: select user_entity_id
655: into l_user_entity_id
656: from ff_database_items
657: where user_name = p_dbi_name;
658:
659: return l_user_entity_id;
660:

Line 2388: from ff_database_items

2384: update ff_archive_items ffai
2385: set ffai.value = 0
2386: where ffai.user_entity_id in (
2387: select user_entity_id
2388: from ff_database_items
2389: where user_name in ('A_SUI_ER_SUBJ_WHABLE_PER_JD_GRE_QTD',
2390: 'A_SUI_ER_SUBJ_NWHABLE_PER_JD_GRE_QTD',
2391: 'A_SUI_ER_125_REDNS_PER_JD_GRE_QTD',
2392: 'A_SUI_ER_401_REDNS_PER_JD_GRE_QTD',