APPS.PAY_ZA_ARCHIVE_DBITEMS_PKG dependencies on FF_CONTEXTS

Line 22: from ff_contexts

18:
19: -- Find the Context ID's
20: select context_id
21: into l_assignment_action_context_id
22: from ff_contexts
23: where context_name = 'ASSIGNMENT_ACTION_ID';
24:
25: select context_id
26: into l_source_context_id

Line 27: from ff_contexts

23: where context_name = 'ASSIGNMENT_ACTION_ID';
24:
25: select context_id
26: into l_source_context_id
27: from ff_contexts
28: where context_name = 'SOURCE_ID';
29:
30: select context_id
31: into l_source_text_context_id

Line 32: from ff_contexts

28: where context_name = 'SOURCE_ID';
29:
30: select context_id
31: into l_source_text_context_id
32: from ff_contexts
33: where context_name = 'SOURCE_TEXT';
34:
35: select context_id
36: into l_source_number_context_id

Line 37: from ff_contexts

33: where context_name = 'SOURCE_TEXT';
34:
35: select context_id
36: into l_source_number_context_id
37: from ff_contexts
38: where context_name = 'SOURCE_NUMBER';
39:
40: -------------------------------------------------------------------------
41: -- Define the number archive route

Line 480: ff_contexts fc

476:
477: l_text :=
478: ' ff_archive_items target,
479: ff_archive_item_contexts faic,
480: ff_contexts fc
481: where target.user_entity_id = &U1
482: and target.context1 = &B1 /* context assignment action id */
483: And target.archive_item_id = faic.archive_item_id
484: and fc.context_name = ''SOURCE_TEXT''

Line 575: ff_contexts fc

571:
572: l_text :=
573: ' ff_archive_items target,
574: ff_archive_item_contexts faic,
575: ff_contexts fc
576: where target.user_entity_id = &U1
577: and target.context1 = &B1 /* context assignment action id */
578: And target.ARCHIVE_ITEM_ID = faic.ARCHIVE_ITEM_ID
579: and fc.context_name = ''SOURCE_NUMBER''