APPS.HR_POSITION_REQUIREMENT_API SQL Statements

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

Line: 132

    select business_group_id
    from hr_positions_f
    where position_id = p_position_id;

Line: 139

     select 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_analysis_criteria
    where  analysis_criteria_id = l_analysis_criteria_id;