APPS.JTF_ACTIVITY_MANAGER dependencies on JTF_ACT_TYPES_ATTRS_TL

Line 7: v_attrname jtf_act_types_attrs_tl.attribute_name%TYPE;

3:
4: procedure write(
5: appid IN number, activityname IN varchar2, attrnames IN t_valuetable, valuen IN t_valuetable ) is
6:
7: v_attrname jtf_act_types_attrs_tl.attribute_name%TYPE;
8: v_userid jtf_act_activity_logs.jtf_act_activity_logs_user_id%TYPE ;
9: v_component jtf_act_activity_logs.component%TYPE ;
10: v_numvalue number;
11: v_tablename jtf_act_types_b.table_name%TYPE;

Line 21: from jtf_act_types_tl t1, jtf_act_types_attrs_b b, jtf_act_types_attrs_tl t2

17: activitynameid number;
18:
19: cursor C is
20: SELECT t2.attribute_name, to_number(LTRIM(b.column_name, 'column'))
21: from jtf_act_types_tl t1, jtf_act_types_attrs_b b, jtf_act_types_attrs_tl t2
22: where t1.activity_name = activityname and t1.language=userenv('LANG')
23: and t1.activity_name_id = b.activity_name_id
24: and b.attribute_name_id = t2.attribute_name_id and t2.language=userenv('LANG');
25: