APPS.PQH_PSP_INTEGRATION SQL Statements

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

Line: 31

 Select start_date,end_date
   From per_time_periods
   Where time_period_id = p_time_period_id;

Line: 140

Select position_id ,organization_id,
       grade_id,job_id,
       effective_start_date,effective_end_date
 From per_all_assignments_f
 Where assignment_id=p_assignment_id And
       position_id is not null And
       effective_start_date >= p_start_date And
       effective_end_date   <= p_end_date;

Line: 207

Select bdt.budget_detail_id ,bdt.budget_version_id
From   pqh_budget_details  bdt,
       pqh_budget_versions bvr,
       pqh_budgets         bgt
Where
     bdt.position_id=p_position_id And
     bdt.gl_status='POST' And
     bvr.budget_version_id=bdt.budget_version_id And
     bvr.gl_status='POST' And
     bgt.budget_id=bvr.budget_id And
     bgt.TRANSFER_TO_GRANTS_FLAG='Y' And
     bgt.budgeted_entity_cd='POSITION'AND
     ( (bgt.budget_start_date>=p_start_date and bgt.budget_start_date < p_end_date) Or
       (bgt.budget_end_date > P_start_date and bgt.budget_end_date   <=p_end_date )Or
       (p_start_date >=bgt.budget_end_date and p_start_date < bgt.budget_end_date )
     );

Line: 228

Select bdt.budget_detail_id ,bdt.budget_version_id
From   pqh_budget_details  bdt,
       pqh_budget_versions bvr,
       pqh_budgets         bgt
Where
     bdt.organization_id=p_organization_id And
     bdt.gl_status='POST' And
     bvr.budget_version_id=bdt.budget_version_id And
     bvr.gl_status='POST' And
     bgt.budget_id=bvr.budget_id And
     bgt.TRANSFER_TO_GRANTS_FLAG='Y' And
     bgt.budgeted_entity_cd='ORGANIZATION'AND
     ( (bgt.budget_start_date>=p_start_date and bgt.budget_start_date < p_end_date) Or
       (bgt.budget_end_date > P_start_date and bgt.budget_end_date   <=p_end_date )Or
       (p_start_date >=bgt.budget_end_date and p_start_date < bgt.budget_end_date )
     );

Line: 250

Select bdt.budget_detail_id ,bdt.budget_version_id
From   pqh_budget_details  bdt,
       pqh_budget_versions bvr,
       pqh_budgets         bgt
Where
     bdt.grade_id=p_grade_id And
     bdt.gl_status='POST' And
     bvr.budget_version_id=bdt.budget_version_id And
     bvr.gl_status='POST' And
     bgt.budget_id=bvr.budget_id And
     bgt.TRANSFER_TO_GRANTS_FLAG='Y' And
     bgt.budgeted_entity_cd='GRADE'AND
     ( (bgt.budget_start_date>=p_start_date and bgt.budget_start_date < p_end_date) Or
       (bgt.budget_end_date > P_start_date and bgt.budget_end_date   <=p_end_date )Or
       (p_start_date >=bgt.budget_end_date and p_start_date < bgt.budget_end_date )
     );

Line: 271

Select bdt.budget_detail_id ,bdt.budget_version_id
From   pqh_budget_details  bdt,
       pqh_budget_versions bvr,
       pqh_budgets         bgt
Where
     bdt.job_id=p_job_id And
     bdt.gl_status='POST' And
     bvr.budget_version_id=bdt.budget_version_id And
     bvr.gl_status='POST' And
     bgt.budget_id=bvr.budget_id And
     bgt.TRANSFER_TO_GRANTS_FLAG='Y' And
     bgt.budgeted_entity_cd='JOB'AND
     ( (bgt.budget_start_date>=p_start_date and bgt.budget_start_date < p_end_date) Or
       (bgt.budget_end_date > P_start_date and bgt.budget_end_date   <=p_end_date )Or
       (p_start_date >=bgt.budget_end_date and p_start_date < bgt.budget_end_date )
     );

Line: 328

    Update pqh_budget_details
      SET commitment_gl_status='ENC',gl_status='ENC'
    Where budget_detail_id = C1.budget_detail_id;

Line: 360

     Update pqh_budget_details
       SET commitment_gl_status='ENC',gl_status='ENC'
     Where budget_detail_id = C1.budget_detail_id;

Line: 392

      Update pqh_budget_details
       SET commitment_gl_status='ENC',gl_status='ENC'
      Where budget_detail_id = C1.budget_detail_id;

Line: 424

      Update pqh_budget_details
        SET commitment_gl_status='ENC',gl_status='ENC'
      Where budget_detail_id = C1.budget_detail_id;