APPS.JTF_ACTIVITY_MANAGER dependencies on JTF_ACT_TYPES_TL

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:

Line 29: from jtf_act_types_b b, jtf_act_types_tl tl

25:
26:
27: cursor C2 is
28: SELECT b.table_name
29: from jtf_act_types_b b, jtf_act_types_tl tl
30: where b.activity_name_id = tl.activity_name_id
31: and tl.activity_name = activityname
32: and tl.language = userenv('LANG');
33: begin

Line 78: select activity_name_id into activitynameid from jtf_act_types_tl

74:
75: end loop;
76: close c2;
77:
78: select activity_name_id into activitynameid from jtf_act_types_tl
79: where language = userenv('LANG') and activity_name = activityname;
80:
81: cid := DBMS_SQL.OPEN_CURSOR;
82: