APPS.PA_BILLING_SCHEDULE_UTILS SQL Statements

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

Line: 37

     SELECT brs.bill_rate_sch_id
       FROM pa_std_bill_rate_schedules brs, pa_lookups l
      WHERE brs.schedule_type = 'EMPLOYEE'
        AND brs.std_bill_rate_schedule = p_emp_bill_rate_name
        AND l.lookup_type = 'SCHEDULE TYPE'
        AND l.lookup_code (+) = brs.schedule_type;

Line: 50

          SELECT brs.bill_rate_sch_id
            INTO x_emp_bill_rate_id
            FROM pa_std_bill_rate_schedules brs, pa_lookups l
           WHERE brs.schedule_type = 'EMPLOYEE'
             AND brs.bill_rate_sch_id = p_emp_bill_rate_id
             AND l.lookup_type = 'SCHEDULE TYPE'
             AND l.lookup_code (+) = brs.schedule_type;

Line: 94

            SELECT brs.bill_rate_sch_id
              INTO x_emp_bill_rate_id
              FROM pa_std_bill_rate_schedules brs, pa_lookups l
             WHERE brs.schedule_type = 'EMPLOYEE'
               AND brs.std_bill_rate_schedule = p_emp_bill_rate_name
               AND l.lookup_type = 'SCHEDULE TYPE'
               AND l.lookup_code (+) = brs.schedule_type;

Line: 156

     SELECT brs.bill_rate_sch_id
       FROM pa_std_bill_rate_schedules brs, pa_lookups l
      WHERE brs.schedule_type = 'JOB'
        AND brs.std_bill_rate_schedule = p_job_bill_rate_name
        AND brs.job_group_id = p_job_group_id
        AND l.lookup_type = 'SCHEDULE TYPE'
        AND l.lookup_code (+) = brs.schedule_type;

Line: 170

          SELECT brs.bill_rate_sch_id
            INTO x_job_bill_rate_id
            FROM pa_std_bill_rate_schedules brs, pa_lookups l
           WHERE brs.schedule_type = 'JOB'
             AND brs.bill_rate_sch_id = p_job_bill_rate_id
             AND brs.job_group_id = p_job_group_id
             AND l.lookup_type = 'SCHEDULE TYPE'
             AND l.lookup_code (+) = brs.schedule_type;

Line: 215

          SELECT brs.bill_rate_sch_id
            INTO x_job_bill_rate_id
            FROM pa_std_bill_rate_schedules brs, pa_lookups l
           WHERE brs.schedule_type = 'JOB'
             AND brs.std_bill_rate_schedule = p_job_bill_rate_name
             AND brs.job_group_id = p_job_group_id
             AND l.lookup_type = 'SCHEDULE TYPE'
             AND l.lookup_code (+) = brs.schedule_type;

Line: 277

           SELECT irs.ind_rate_sch_id
             FROM pa_lookups l, pa_ind_rate_schedules irs
            WHERE l.lookup_type = 'IND RATE SCHEDULE TYPE'
              AND l.lookup_code = irs.ind_rate_schedule_type
              AND irs.project_id IS NULL
              AND trunc(sysdate) BETWEEN irs.start_date_active
                                 AND nvl(irs.end_date_active,trunc(sysdate+1))
              AND irs.ind_rate_sch_name = p_rev_sch_name ;

Line: 291

           SELECT irs.ind_rate_sch_id
             INTO x_rev_sch_id
             FROM pa_lookups l, pa_ind_rate_schedules irs
            WHERE l.lookup_type = 'IND RATE SCHEDULE TYPE'
              AND l.lookup_code = irs.ind_rate_schedule_type
              AND irs.project_id IS NULL
              AND trunc(sysdate) BETWEEN irs.start_date_active
                                 AND nvl(irs.end_date_active,trunc(sysdate+1))
              AND irs.ind_rate_sch_id = p_rev_sch_id;

Line: 338

           SELECT irs.ind_rate_sch_id
             INTO x_rev_sch_id
             FROM pa_lookups l, pa_ind_rate_schedules irs
            WHERE l.lookup_type = 'IND RATE SCHEDULE TYPE'
              AND l.lookup_code = irs.ind_rate_schedule_type
              AND irs.project_id IS NULL
              AND trunc(sysdate) BETWEEN irs.start_date_active
                                 AND nvl(irs.end_date_active,trunc(sysdate+1))
              AND irs.ind_rate_sch_name = p_rev_sch_name ;

Line: 401

           SELECT irs.ind_rate_sch_id
             FROM pa_lookups l, pa_ind_rate_schedules irs
            WHERE l.lookup_type = 'IND RATE SCHEDULE TYPE'
              AND l.lookup_code = irs.ind_rate_schedule_type
              AND irs.project_id IS NULL
              AND trunc(sysdate) BETWEEN irs.start_date_active
                                 AND nvl(irs.end_date_active,trunc(sysdate+1))
              AND irs.ind_rate_sch_name = p_inv_sch_name ;

Line: 415

           SELECT irs.ind_rate_sch_id
             INTO x_inv_sch_id
             FROM pa_lookups l, pa_ind_rate_schedules irs
            WHERE l.lookup_type = 'IND RATE SCHEDULE TYPE'
              AND l.lookup_code = irs.ind_rate_schedule_type
              AND irs.project_id IS NULL
              AND trunc(sysdate) BETWEEN irs.start_date_active
                                 AND nvl(irs.end_date_active,trunc(sysdate+1))
              AND irs.ind_rate_sch_id = p_inv_sch_id;

Line: 462

           SELECT irs.ind_rate_sch_id
             INTO x_inv_sch_id
             FROM pa_lookups l, pa_ind_rate_schedules irs
            WHERE l.lookup_type = 'IND RATE SCHEDULE TYPE'
              AND l.lookup_code = irs.ind_rate_schedule_type
              AND irs.project_id IS NULL
              AND trunc(sysdate) BETWEEN irs.start_date_active
                                 AND nvl(irs.end_date_active,trunc(sysdate+1))
              AND irs.ind_rate_sch_name = p_inv_sch_name ;

Line: 524

          SELECT brs.std_bill_rate_schedule
            INTO x_sch_name
            FROM pa_std_bill_rate_schedules brs, pa_lookups l
           WHERE organization_id = p_nlbr_org_id
             AND brs.schedule_type = 'NON-LABOR'
             AND l.lookup_type = 'SCHEDULE TYPE'
             AND l.lookup_code (+) = brs.schedule_type
             AND brs.std_bill_rate_schedule = p_sch_name;

Line: 587

           SELECT o.organization_id
             FROM pa_organizations_sbrs_v o
            WHERE o.schedule_type = 'NON-LABOR'
              AND o.name = p_org_name;

Line: 597

           SELECT o.organization_id
             INTO x_org_id
             FROM pa_organizations_sbrs_v o
            WHERE o.schedule_type = 'NON-LABOR'
              AND o.organization_id = p_org_id;

Line: 639

           SELECT o.organization_id
             INTO x_org_id
             FROM pa_organizations_sbrs_v o
            WHERE o.schedule_type = 'NON-LABOR'
              AND o.name = p_org_name;

Line: 694

     SELECT 'x'
       FROM pa_labor_multipliers
      WHERE project_id  = p_project_id
        AND NVL( TASK_ID, -1 ) = DECODE( p_task_id, NULL, -1, p_task_id )
        AND (p_effective_from_date BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, p_effective_from_date + 1)
             OR  p_effective_to_date BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, p_effective_to_date + 1)
             OR  START_DATE_ACTIVE BETWEEN p_effective_from_date AND NVL(p_effective_to_date, START_DATE_ACTIVE + 1))
        AND ( p_labor_multiplier_id IS NULL OR labor_multiplier_id <> p_labor_multiplier_id );

Line: 785

         SELECT bill_job_group_id
           FROM pa_projects_prm_v
          WHERE project_id = p_project_id;

Line: 824

    SELECT ppt.project_type_class_code
      FROM pa_projects_all ppa, pa_project_types ppt
     WHERE ppa.project_id = p_project_id
       AND ppa.project_type = ppt.project_type;