APPS.PAY_US_ARCHIVE_UTIL dependencies on FF_ARCHIVE_ITEMS

Line 71: FROM ff_archive_items fai, ff_archive_item_contexts fic

67: cp_tax_context_id NUMBER
68: )
69: IS
70: SELECT fai.VALUE
71: FROM ff_archive_items fai, ff_archive_item_contexts fic
72: WHERE fai.context1 = cp_action_id
73: AND fai.user_entity_id = cp_user_entity_id
74: AND fai.archive_item_id = fic.archive_item_id
75: AND fic.context_id = cp_tax_context_id

Line 92: ff_archive_items fai

88: FROM ff_archive_item_contexts faic2,
89: ff_archive_item_contexts faic1,
90: ff_contexts fc2,
91: ff_contexts fc1,
92: ff_archive_items fai
93: WHERE fai.user_entity_id = cp_user_entity_id
94: AND fai.context1 = cp_action_id
95: AND fc2.context_name = 'TAX_UNIT_ID'
96: AND fc1.context_name = 'JURISDICTION_CODE'

Line 108: lv_return_value ff_archive_items.value%TYPE;

104: lv_tax_context_id NUMBER;
105: lv_table_count NUMBER;
106: lv_user_entity_id ff_user_entities.user_entity_id%TYPE;
107: lv_user_entity_name ff_user_entities.user_entity_name%TYPE;
108: lv_return_value ff_archive_items.value%TYPE;
109: BEGIN
110: lv_tax_context_id := -1;
111: lv_table_count := 0;
112: lv_user_entity_id := NULL;