APPS.PA_HR_TRANSACTIONS SQL Statements

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

Line: 13

                select  null
                from    PA_TRANSACTION_INTERFACE_ALL         pa,
                        --FP M CWK changes
                        --PER_PEOPLE_F                        ppf
                        PER_ALL_PEOPLE_F                        ppf
                --where   pa.employee_number         = ppf.employee_number
                where   pa.employee_number         in (ppf.employee_number, ppf.npw_number)
                and     ppf.person_id              = P_PERSON_ID
                AND     pa.transaction_status_code <> 'A';

Line: 24

                select  null
                from    PA_ROUTINGS         pa
                where   pa.routed_from_person_id         = P_PERSON_ID
                        OR  pa.routed_to_person_id       = P_PERSON_ID;

Line: 31

                select  null
                from    PA_PTE_MULTI_ORG_EMP_MAP         pa
                where   pa.person_id                    = P_PERSON_ID;

Line: 37

                select  null
                from    PA_ONLINE_EXP_SETTINGS         pa
                where   pa.person_id                    = P_PERSON_ID;

Line: 42

                select  null
                from    PA_EXPEND_COMMENT_ALIASES         pa
                where   pa.person_id                    = P_PERSON_ID;

Line: 48

                select  null
                from    PA_EI_DENORM         pa
                where   pa.person_id       = P_PERSON_ID;

Line: 54

                select  null
                from    pa_expenditures_all                 pa
                where   pa.incurred_by_person_id        = P_PERSON_ID;

Line: 59

                select  null
                from    pa_transaction_controls         pa
                where   pa.project_id > -1
                  and   pa.person_id                    = P_PERSON_ID;

Line: 75

      SELECT null
      INTO   dummy1
      FROM   pa_transaction_interface_all
      WHERE  person_id = p_person_id
      AND    transaction_status_code <> 'A'
      AND    rownum = 1;

Line: 175

            SELECT 'Y'
              FROM DUAL
             WHERE EXISTS (
                select  null
                from    pa_expenditure_items_all      pa
                where   (pa.job_id    is not null
                        AND pa.job_id      = P_JOB_ID)
                        OR
                        (pa.bill_job_id is not null
                        AND pa.bill_job_id = P_JOB_ID));

Line: 190

 SELECT 'Y'
   FROM
    DUAL WHERE EXISTS
        (( SELECT NULL FROM PA_EXPENDITURE_ITEMS_ALL PA WHERE
           PA.JOB_ID IS NOT NULL AND PA.JOB_ID = P_JOB_ID )
           UNION
           (SELECT NULL FROM PA_EXPENDITURE_ITEMS_ALL PA WHERE
            PA.BILL_JOB_ID IS NOT  NULL AND PA.BILL_JOB_ID = P_JOB_ID )
         );

Line: 202

                select  null
                from    pa_ei_denorm      pa
                where (pa.job_id_1 is not null
                         AND pa.job_id_1         = P_JOB_ID )
                       OR (pa.job_id_2 is not null
                         AND pa.job_id_2         = P_JOB_ID )
                       OR (pa.job_id_3 is not null
                         AND pa.job_id_3         = P_JOB_ID )
                       OR (pa.job_id_4 is not null
                         AND pa.job_id_4         = P_JOB_ID )
                       OR (pa.job_id_5 is not null
                         AND pa.job_id_5         = P_JOB_ID )
                       OR (pa.job_id_6 is not null
                         AND pa.job_id_6         = P_JOB_ID )
                       OR (pa.job_id_7 is not null
                         AND pa.job_id_7         = P_JOB_ID );

Line: 222

    select * from pa_expenditures_all
    where  expenditure_class_code  = 'PT'
    and    expenditure_status_code = 'APPROVED'
    and    transfer_status_code    = 'P';

Line: 228

    select expenditure_item_date_1, quantity_1,
           expenditure_item_date_2, quantity_2,
           expenditure_item_date_3, quantity_3,
           expenditure_item_date_4, quantity_4,
           expenditure_item_date_5, quantity_5,
           expenditure_item_date_6, quantity_6,
           expenditure_item_date_7, quantity_7,
	   person_id
    from   pa_ei_denorm
    where  expenditure_id = p_exp_id;