APPS.PQP_HRTCA_SYNCHRONIZATION SQL Statements

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

Line: 13

    SELECT pei.pei_information5
      FROM per_people_extra_info  pei
     WHERE pei.information_type         = 'PQP_OSS_PERSON_DETAILS'
       AND pei.pei_information_category = 'PQP_OSS_PERSON_DETAILS'
       AND pei.person_id                = c_person_id;

Line: 21

    SELECT ppf.party_id,pbg.legislation_code
      FROM per_all_people_f ppf
          ,per_business_groups_perf pbg
     WHERE ppf.person_id = c_person_id
       AND pbg.business_group_id = ppf.business_group_id;

Line: 29

   SELECT pbg.legislation_code
     FROM per_business_groups pbg
    WHERE pbg.business_group_id = c_bg_grp_id;

Line: 147

        ,p_action           => 'INSERT'
        ,p_pei_info_rec_old => NULL
        ,p_pei_info_rec_new => l_pei_rec
         );

Line: 156

        ,p_action           => 'INSERT'
        ,p_pei_info_rec_old => NULL
        ,p_pei_info_rec_new => l_pei_rec
         );

Line: 165

        ,p_action           => 'INSERT'
        ,p_pei_info_rec_old => NULL
        ,p_pei_info_rec_new => l_pei_rec
         );

Line: 362

        ,p_action           => 'UPDATE'
        ,p_pei_info_rec_old => l_pei_rec_old
        ,p_pei_info_rec_new => l_pei_rec_new
         );

Line: 371

        ,p_action           => 'UPDATE'
        ,p_pei_info_rec_old => l_pei_rec_old
        ,p_pei_info_rec_new => l_pei_rec_new
         );

Line: 379

        ,p_action           => 'UPDATE'
        ,p_pei_info_rec_old => l_pei_rec_old
        ,p_pei_info_rec_new => l_pei_rec_new
         );