Monday, October 5, 2015

To get approved leaves



         SELECT pat.NAME absence_type, paa.date_start leave_start_date,
                paa.date_end leave_end_date, paa.absence_days, paa.abs_information_category,
                paa.abs_information2, paa.abs_information3,paa.abs_information4
           FROM per_absence_attendances paa,
                per_absence_attendance_types pat,
                per_all_people_f papf
          WHERE paa.absence_attendance_type_id =
                                                pat.absence_attendance_type_id
            AND papf.person_id = paa.person_id
            AND TRUNC (paa.date_start) BETWEEN TRUNC
                                                    (papf.effective_start_date)
                                           AND TRUNC (papf.effective_end_date)
            AND TRUNC (p_date) BETWEEN TRUNC (paa.date_start)
                                   AND TRUNC (NVL (paa.date_end,
                                                   paa.date_start
                                                  )
                                             )
            AND papf.person_id = :p_person_id;

2 comments:

  1. I was diagnosed with stage 3 breast cancer in August of 2010. A precious friend told me about Dr Itua Herbal Center in West Africa,She gave me his contact number and email address,I contacted him quickly so he give me guaranty that his herbal medicine will cure my cancer and i will be heal forever I said Okay.I ask him about the process for the cure,he ask me to pay for the fees which i did and within 7 working days he sent me the herbal medicine then he instructed me on how to drink it for two weeks to cure.I told Gomez my friend about the herbal medicine so he gave me go ahead to drink it.So after drinking it for two weeks i was cured I'm so grateful and i promise i will recommend anyone with cancer to him and that what i'm doing.Dr Itua Herbal Medicine makes me believes there is a hope for people suffering from,Parkinson's disease,Schizophrenia,Cancer,Scoliosis,Bladder Cancer,Colorectal Cancer,Breast Cancer,Kidney Cancer,Leukemia,Lung Cancer,Skin Cancer,Uterine Cancer,Prostate Cancer,Fibromyalgia,a
    Syndrome Fibrodysplasia ,Epilepsy Dupuytren's disease, Diabetes ,Coeliac disease, Angiopathy, Ataxia,Arthritis,Amyotrophic Lateral Sclerosis,Alzheimer's disease,Adrenocortical carcinoma.Asthma,Allergic diseases.Hiv_ Aids,Herpes,Inflammatory bowel disease ,Copd,Diabetes.
    Here Is His Contact Info......[Email...drituaherbalcenter@gmail.com/Whatsapp...+2348149277967]

    ReplyDelete
  2. Most prostate cancers are adenocarcinomas, cancers that arise in glandular cells of the prostate’s epithelial tissue. Prostate cancers usually progress slowly and produce no symptoms in the initial stages. Eventually, the tumor may enlarge like mine use too, the prostate gland, pressing on the urethra and causing painful or frequent urination and blood in the urine. So I was so uncomfortable with this prostate cancer diseases then I decided to do online search on how to cure cancer because I well have read a lot about herbal medicine,I came across a lot of testimony how Dr Itua cure HIV/herpes then Cancer was listed below the comment.with courage I contacted Dr Itua and he sent me his herbal medicine through Courier service then I was asked to pick it up at my post office which i quickly did. I contacted Dr Itua that i have received my herbal medicine so he instructs me on how to drink it for three weeks and that is how Dr Itua Herbal Medicine cure my prostate Cancer, The treatment takes three weeks and I was cured completely. Dr Itua is a god sent and I thank him every day of my life. Contact him now On:Email:drituaherbalcenter@gmail.com/Whatsapp:+2348149277967.
    He listed to that he can as well cure the following diseases below.... Cerebral Amides. Lung Cancer, Alzheimer's disease, Adrenocortical carcinoma. Alma, Uterine Cancer, Breast Cancer, Allergic diseases. Kidney cancer, Love Spell, Colo rectal cancer, Lottery Spell, Bladder Cancer, Skin Cancer, HIV /Aids, Herpes, Non-Hodgkin lymphoma, Inflammatory bowel disease, Copd, Diabetes, Hepatitis

    ReplyDelete