APPS.PAY_CA_EOY_RL1_ARCHIVE dependencies on FF_DATABASE_ITEMS

Line 296: ff_database_items DI

292:
293: cursor csr_defined_balance is
294: select to_number(UE.creator_id)
295: from ff_user_entities UE,
296: ff_database_items DI
297: where DI.user_name = p_db_item_name
298: and UE.user_entity_id = DI.user_entity_id
299: and Ue.creator_type = 'B';
300:

Line 498: from ff_database_items

494: begin
495:
496: select user_entity_id
497: into l_user_entity_id
498: from ff_database_items
499: where user_name = p_dbi_name;
500:
501: return l_user_entity_id;
502:

Line 530: from ff_database_items

526: if p_dbi_name is not null then
527: begin
528: select user_entity_id
529: into l_user_entity_id
530: from ff_database_items
531: where user_name = p_dbi_name;
532:
533: return l_user_entity_id;
534:

Line 606: ff_database_items fdi1,

602: SELECT fai1.context1,
603: fdi1.user_entity_id,
604: fai1.value
605: FROM ff_archive_items fai1,
606: ff_database_items fdi1,
607: ff_archive_item_contexts faic,
608: ff_contexts fc
609: WHERE fai1.user_entity_id = fdi1.user_entity_id
610: AND fai1.archive_item_id = faic.archive_item_id

Line 2305: ff_database_items fdi

2301: /* New cursors added for Provincial YE Amendment Pre-Process Validation */
2302: CURSOR c_get_fapp_prov_emp(cp_assignment_action_id number) IS
2303: select fai.value
2304: from ff_archive_items fai,
2305: ff_database_items fdi
2306: where fdi.user_entity_id = fai.user_entity_id
2307: and fai.context1 = cp_assignment_action_id
2308: and fdi.user_name = 'CAEOY_RL1_PROVINCE_OF_EMPLOYMENT';
2309: