APPS.PV_WORKFLOW_PUB dependencies on WF_PROCESS_ACTIVITIES

Line 1180: -- wf_process_activities, wf_activity_transitions) but if the

1176: l_msg_count number;
1177: l_msg_data varchar2(2000);
1178:
1179: -- this can be written using just joins (wf_item_activity_statuses,
1180: -- wf_process_activities, wf_activity_transitions) but if the
1181: -- timeout transition in WF is removed, it will not work
1182:
1183: cursor lc_chk_for_timeout (pc_itemtype varchar2,
1184: pc_itemkey varchar2,

Line 1193: from wf_process_activities c, wf_activity_transitions d

1189: where a.item_type = pc_itemtype
1190: and a.item_key = pc_itemkey
1191: and a.process_activity =
1192: (select d.from_process_activity
1193: from wf_process_activities c, wf_activity_transitions d
1194: where d.to_process_activity = pc_to_activity_id
1195: and d.from_process_activity = c.instance_id
1196: and c.activity_name = pc_from_activity_name and rownum < 2);
1197: