APPS.PER_POD_SHD SQL Statements

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

Line: 56

    select  pbg.position_structure
    from    per_business_groups pbg
    where   pbg.business_group_id = p_business_group_id;

Line: 62

    select pod.position_definition_id
      from per_positions pod
      where name = p_name
      and   exists (select 'x'
                    from  per_position_definitions ppd
                    where ppd.position_definition_id = pod.position_definition_id
                    and   ppd.id_flex_num   = l_id_flex_num
                    and   ppd.enabled_flag  = 'Y');

Line: 336

    select
	position_definition_id,
	id_flex_num,
	summary_flag,
	enabled_flag,
	start_date_active,
	end_date_active,
	segment1,
	segment2,
	segment3,
	segment4,
	segment5,
	segment6,
	segment7,
	segment8,
	segment9,
	segment10,
	segment11,
	segment12,
	segment13,
	segment14,
	segment15,
	segment16,
	segment17,
	segment18,
	segment19,
	segment20,
	segment21,
	segment22,
	segment23,
	segment24,
	segment25,
	segment26,
	segment27,
	segment28,
	segment29,
	segment30
    from	per_position_definitions
    where	position_definition_id = p_position_definition_id;