APPS.HR_TASKFLOW_WORKFLOW dependencies on WF_ACTIVITIES

Line 41: g_activity_display_name wf_activities_tl.display_name%type;

37: g_root_process_id wf_process_activities.instance_id%type;
38: g_business_group_id pay_customized_restrictions.business_group_id%type;
39: g_legislation_code pay_customized_restrictions.legislation_code%type;
40: g_legislation_subgroup pay_customized_restrictions.legislation_subgroup%type;
41: g_activity_display_name wf_activities_tl.display_name%type;
42: g_process_display_name wf_activities_tl.display_name%type;
43: g_item_type_display_name wf_item_types_tl.display_name%type;
44: g_language varchar2(30);
45: g_converted_processes number;

Line 42: g_process_display_name wf_activities_tl.display_name%type;

38: g_business_group_id pay_customized_restrictions.business_group_id%type;
39: g_legislation_code pay_customized_restrictions.legislation_code%type;
40: g_legislation_subgroup pay_customized_restrictions.legislation_subgroup%type;
41: g_activity_display_name wf_activities_tl.display_name%type;
42: g_process_display_name wf_activities_tl.display_name%type;
43: g_item_type_display_name wf_item_types_tl.display_name%type;
44: g_language varchar2(30);
45: g_converted_processes number;
46: --

Line 93: from wf_activities_tl wat1

89: cursor csr_sel_names is
90: select wat1.display_name activity_display_name
91: ,witt.display_name item_display_name
92: ,wat2.display_name process_display_name
93: from wf_activities_tl wat1
94: ,wf_activities_tl wat2
95: ,wf_activities wa1
96: ,wf_activities wa2
97: ,wf_item_types_tl witt

Line 94: ,wf_activities_tl wat2

90: select wat1.display_name activity_display_name
91: ,witt.display_name item_display_name
92: ,wat2.display_name process_display_name
93: from wf_activities_tl wat1
94: ,wf_activities_tl wat2
95: ,wf_activities wa1
96: ,wf_activities wa2
97: ,wf_item_types_tl witt
98: ,wf_process_activities wpa

Line 95: ,wf_activities wa1

91: ,witt.display_name item_display_name
92: ,wat2.display_name process_display_name
93: from wf_activities_tl wat1
94: ,wf_activities_tl wat2
95: ,wf_activities wa1
96: ,wf_activities wa2
97: ,wf_item_types_tl witt
98: ,wf_process_activities wpa
99: where wpa.instance_id = p_instance_id

Line 96: ,wf_activities wa2

92: ,wat2.display_name process_display_name
93: from wf_activities_tl wat1
94: ,wf_activities_tl wat2
95: ,wf_activities wa1
96: ,wf_activities wa2
97: ,wf_item_types_tl witt
98: ,wf_process_activities wpa
99: where wpa.instance_id = p_instance_id
100: and witt.name = wpa.activity_item_type

Line 558: from wf_activities wa

554: -- activity instance
555: cursor csr_attivity_type(c_instance_id number) is
556: select wa.type
557: ,wpa.start_end
558: from wf_activities wa
559: ,wf_process_activities wpa
560: where wpa.instance_id = c_instance_id
561: and wa.item_type = wpa.activity_item_type
562: and wa.name = wpa.activity_name

Line 1368: from wf_activities wa

1364: ,p_process_name in varchar2) is
1365: --
1366: cursor l_csr_processes(c_instance_id wf_process_activities.instance_id%type) is
1367: select wpa1.instance_id
1368: from wf_activities wa
1369: ,wf_process_activities wpa1
1370: ,wf_process_activities wpa2
1371: where wpa2.instance_id = c_instance_id
1372: and wpa1.process_name = wpa2.activity_name

Line 1387: from wf_activities wa

1383: --
1384: cursor l_csr_tf_form_activity
1385: (c_instance_id wf_process_activities.instance_id%type) is
1386: select wpa1.instance_id
1387: from wf_activities wa
1388: ,wf_process_activities wpa1
1389: ,wf_process_activities wpa2
1390: ,wf_activity_attr_values waav
1391: ,wf_activity_attributes waa

Line 1416: from wf_activities wa

1412: cursor l_csr_tf_form_attributes
1413: (c_instance_id wf_process_activities.instance_id%type) is
1414: select waa.name
1415: ,waav.text_value
1416: from wf_activities wa
1417: ,wf_process_activities wpa1
1418: ,wf_activity_attr_values waav
1419: ,wf_activity_attributes waa
1420: where wpa1.instance_id = c_instance_id