APPS.HR_OFFER_WF SQL Statements

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

Line: 933

       select answer_value
       from   per_assign_proposal_answers
       where  assignment_id = p_assignment_id
       and    proposal_question_name = 'ANNUAL_SALARY';

Line: 941

       select answer_value
       from   per_assign_proposal_answers
       where  assignment_id = p_assignment_id
       and    proposal_question_name = 'POSITION_TITLE';

Line: 949

       select hou.name
       from   per_assignments_x pax,
              hr_all_organization_units hou     -- 09/26/97 Changed
       where  pax.assignment_id = p_assignment_id
       and    pax.organization_id = hou.organization_id;

Line: 958

       select answer_value
       from   per_assign_proposal_answers
       where  assignment_id = p_assignment_id
       and    proposal_question_name = 'SIGN_ON_BONUS_AMOUNT';

Line: 966

       select answer_value
       from   per_assign_proposal_answers
       where  assignment_id = p_assignment_id
       and    proposal_question_name = 'RELOCATION_MAXIMUM_AMOUNT_REIMBURSED';

Line: 974

       select answer_value
       from   per_assign_proposal_answers
       where  assignment_id = p_assignment_id
       and    proposal_question_name = 'STOCK_OPTION_SHARES';