APPS.HR_WORKFLOW_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 25

	select	w.workflow_id,
		u.form_name,
		u.block_name,
		nu.nav_node_usage_id
	from	hr_workflows w,
		hr_navigation_node_usages nu,
		hr_navigation_nodes n,
		hr_navigation_units u
	where	w.workflow_id	= nu.workflow_id
	and	nu.top_node	= 'Y'
	and	nu.nav_node_id	= n.nav_node_id
	and	n.nav_unit_id	= u.nav_unit_id
	and	u.default_workflow_id + 0	= w.workflow_id  -- Bug 3390412
	and	u.form_name	= P_CURRENT_FORM;

Line: 41

	select	w.workflow_id,
		u.form_name,
		u.block_name,
		nu.nav_node_usage_id
	from	hr_workflows w,
		hr_navigation_node_usages nu,
		hr_navigation_nodes n,
		hr_navigation_units u
	where	w.workflow_name	= P_PARAM_WORKFLOW_NAME
	and	w.workflow_id	= nu.workflow_id
	and	nu.top_node	= 'Y'
	and	nu.nav_node_id	= n.nav_node_id
	and	n.nav_unit_id	= u.nav_unit_id;

Line: 56

	select	r.customized_restriction_id,
		r.application_id,
		r.query_form_title,
		r.standard_form_title,
		r.enabled_flag
	from	hr_navigation_nodes n,
		hr_navigation_node_usages us,
		pay_custom_restrictions_vl r
	where	us.workflow_id		= P_WORKFLOW_ID
	and	us.nav_node_usage_id 	= P_NAV_NODE_USAGE_ID
	and	us.nav_node_id		= n.nav_node_id
	and	n.customized_restriction_id = r.customized_restriction_id;