APPS.IEM_TAGPROCESS_PUB dependencies on IEM_TAG_KEYS

Line 61: l_query_result varchar2(256);--iem_tag_keys.value%type;

57: l_key_value keyVals_tbl_type;
58:
59: l_select_csr INTEGER;
60: l_temp varchar2(256);
61: l_query_result varchar2(256);--iem_tag_keys.value%type;
62: l_dummy INTEGER;
63: l_account_flag varchar2(1);
64:
65: v_ErrorCode NUMBER;

Line 82: from iem_tag_keys a, iem_account_tag_keys b

78:
79: cursor c_tags ( p_account_id iem_mstemail_accounts.email_account_id%type)
80: is
81: select a.tag_id, a.tag_type_code, a.value
82: from iem_tag_keys a, iem_account_tag_keys b
83: where a.tag_key_id = b.tag_key_id and b.email_account_id = p_account_id;
84:
85: BEGIN
86: SAVEPOINT getEncryptId_PUB;