APPS.HR_JOB_REQUIREMENT_API SQL Statements

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

Line: 128

    select business_group_id
    from per_jobs_v
    where job_id = p_job_id;

Line: 135

     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;