APPS.PAY_US_ARCHIVE_UTIL dependencies on FF_USER_ENTITIES

Line 60: FROM ff_user_entities

56: IS
57: CURSOR c_get_user_entity_name (cp_user_entity_name VARCHAR2)
58: IS
59: SELECT user_entity_id
60: FROM ff_user_entities
61: WHERE user_entity_name = cp_user_entity_name;
62:
63: CURSOR c_get_value (
64: cp_user_entity_id NUMBER,

Line 106: lv_user_entity_id ff_user_entities.user_entity_id%TYPE;

102: AND substr(faic1.CONTEXT,1,2) = substr(cp_jurisdiction_code,1,2);
103:
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;

Line 107: lv_user_entity_name ff_user_entities.user_entity_name%TYPE;

103:
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;