APPS.GHR_WF_PD_PKG SQL Statements

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

Line: 144

PROCEDURE UpdateRHistoryProcess( itemtype	in varchar2,
					   itemkey  in varchar2,
					   actid	in number,
					   funcmode	in varchar2,
					   result	in OUT NOCOPY varchar2) is
--
--
l_position_description_id     ghr_position_descriptions.position_description_id%TYPE;

Line: 182

    wf_core.context('OF8', 'ghr_wf_pd_pkg.UpdateRHistoryProcess',itemtype, itemkey, to_char(actid), funcmode);

Line: 185

end UpdateRHistoryProcess;

Line: 361

        SELECT  max(pd_routing_history_id)
        FROM    ghr_pd_routing_history
        WHERE   position_description_id = p_position_description_id;

Line: 366

	  SELECT action_taken, user_name, groupbox_id
        FROM   ghr_pd_routing_history
        WHERE  pd_routing_history_id = l_pd_routing_history_id;

Line: 370

			SELECT name
			FROM GHR_GROUPBOXES
			WHERE GROUPBOX_ID = l_groupbox_id;

Line: 468

	SELECT category, routing_group_id
	FROM ghr_position_descriptions
	WHERE position_description_id = p_position_description_id;

Line: 473

		SELECT count(*)
		FROM ghr_pd_classifications
		WHERE position_description_id = p_position_description_id;

Line: 478

		SELECT occupational_code, grade_level, official_title, pay_plan
		FROM ghr_pd_classifications
		WHERE position_description_id = p_position_description_id
            and   class_grade_by = l_class_grade_by;

Line: 485

            SELECT name, description
            FROM ghr_routing_groups
            WHERE routing_group_id = l_routing_group_id;

Line: 490

            SELECT action_taken, date_notification_sent from  ghr_pd_routing_history
            where position_description_id = p_position_description_id
            order by  pd_routing_history_id desc;

Line: 620

        SELECT  max(to_number(item_key))
        FROM    ghr_pd_routing_history
        WHERE   position_description_id = p_position_description_id;

Line: 651

  SELECT pei.pei_information3 routing_group_id
        ,pei.pei_information4 initiator_flag
        ,pei.pei_information5 requester_flag
        ,pei.pei_information6 authorizer_flag
        ,pei.pei_information7 personnelist_flag
        ,pei.pei_information8 approver_flag
        ,pei.pei_information9 reviewer_flag
  FROM   per_people_extra_info  pei
        ,fnd_user               use
  WHERE use.user_name = p_user_name
  AND   pei.person_id = use.employee_id
  AND   pei.information_type = 'GHR_US_PER_WF_ROUTING_GROUPS'
  AND   pei.pei_information3  = (SELECT routing_group_id from
                                 GHR_POSITION_DESCRIPTIONS
                                 WHERE position_description_id = p_position_description_id);

Line: 726

    select 1
    from   wf_item_attribute_values wiav
    where  wiav.item_type = p_item_type
    and    wiav.item_key  = p_item_key
    and    wiav.name      = p_name;

Line: 759

        SELECT  action_taken
        FROM    ghr_pd_routing_history
        WHERE   position_description_id = l_position_description_id
        order by  pd_routing_history_id desc;