APPS.PAY_US_ARCHIVE_UTIL dependencies on FF_ARCHIVE_ITEM_CONTEXTS

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 88: FROM ff_archive_item_contexts faic2,

84: cp_jurisdiction_code VARCHAR2
85: )
86: IS
87: SELECT fai.VALUE
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

Line 89: ff_archive_item_contexts faic1,

85: )
86: IS
87: SELECT fai.VALUE
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