APPS.PAY_CA_EOY_RL1_ARCHIVE dependencies on FF_DATABASE_ITEMS

Line 381: ff_database_items DI

377:
378: cursor csr_defined_balance is
379: select to_number(UE.creator_id)
380: from ff_user_entities UE,
381: ff_database_items DI
382: where DI.user_name = p_db_item_name
383: and UE.user_entity_id = DI.user_entity_id
384: and Ue.creator_type = 'B';
385:

Line 583: from ff_database_items

579: begin
580:
581: select user_entity_id
582: into l_user_entity_id
583: from ff_database_items
584: where user_name = p_dbi_name;
585:
586: return l_user_entity_id;
587:

Line 615: from ff_database_items

611: if p_dbi_name is not null then
612: begin
613: select user_entity_id
614: into l_user_entity_id
615: from ff_database_items
616: where user_name = p_dbi_name;
617:
618: return l_user_entity_id;
619:

Line 691: ff_database_items fdi1,

687: SELECT fai1.context1,
688: fdi1.user_entity_id,
689: fai1.value
690: FROM ff_archive_items fai1,
691: ff_database_items fdi1,
692: ff_archive_item_contexts faic,
693: ff_contexts fc
694: WHERE fai1.user_entity_id = fdi1.user_entity_id
695: AND fai1.archive_item_id = faic.archive_item_id

Line 2203: ff_database_items fdi1,

2199: cursor c_get_arch_seq_num(cp_aaid varchar2,
2200: cp_jurisdiction varchar2) is
2201: SELECT fai1.value, fai1.archive_item_id, fai1.object_version_number
2202: FROM FF_ARCHIVE_ITEMS FAI1,
2203: ff_database_items fdi1,
2204: ff_archive_item_contexts faic,
2205: ff_contexts fc
2206: WHERE FAI1.USER_ENTITY_ID = fdi1.user_entity_id
2207: and fdi1.user_name = 'CAEOY_RL1_PDF_SEQ_NUMBER'

Line 3149: ff_database_items fdi

3145: /* New cursors added for Provincial YE Amendment Pre-Process Validation */
3146: CURSOR c_get_fapp_prov_emp(cp_assignment_action_id number) IS
3147: select fai.value
3148: from ff_archive_items fai,
3149: ff_database_items fdi
3150: where fdi.user_entity_id = fai.user_entity_id
3151: and fai.context1 = cp_assignment_action_id
3152: and fdi.user_name = 'CAEOY_RL1_PROVINCE_OF_EMPLOYMENT';
3153: