The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT person_id
FROM igs_pe_prsid_grp_mem
WHERE group_id = cp_group_id
AND (TRUNC(start_date) <= TRUNC(SYSDATE) OR (start_date IS NULL))
AND (TRUNC(end_date) >= TRUNC(SYSDATE) OR (end_date IS NULL));*/
SELECT person_number,
full_name
FROM igs_pe_person_base_v
WHERE person_id = cp_person_id;
OPEN c_person_id FOR 'SELECT party_id person_id FROM hz_parties WHERE party_id IN (' || l_list || ') ' USING p_person_group_id;
OPEN c_person_id FOR 'SELECT party_id person_id FROM hz_parties WHERE party_id IN (' || l_list || ') ';
SELECT base_id
FROM igf_ap_fa_base_rec
WHERE person_id = cp_person_id
AND ci_cal_type = cp_cal_type
AND ci_sequence_number = cp_sequence_number;
SELECT api_person_id,api_person_id_uf, end_dt
FROM igs_pe_alt_pers_id
WHERE pe_person_id=cp_person_id
AND person_id_type like 'SSN'
AND SYSDATE < = NVL(end_dt,SYSDATE);
igf_ap_fa_base_rec_pkg.insert_row (
X_ROWID => l_rowid ,
X_BASE_ID => l_base_id ,
X_CI_CAL_TYPE => p_cal_type ,
X_PERSON_ID => p_person_id ,
X_CI_SEQUENCE_NUMBER => p_sequence_number,
X_ORG_ID => NULL ,
X_COA_PENDING => NULL ,
X_VERIFICATION_PROCESS_RUN => NULL ,
X_INST_VERIF_STATUS_DATE => NULL ,
X_MANUAL_VERIF_FLAG => NULL ,
X_FED_VERIF_STATUS => NULL ,
X_FED_VERIF_STATUS_DATE => NULL ,
X_INST_VERIF_STATUS => NULL ,
X_NSLDS_ELIGIBLE => NULL ,
X_EDE_CORRECTION_BATCH_ID => NULL ,
X_FA_PROCESS_STATUS_DATE => NULL ,
X_ISIR_CORR_STATUS => NULL ,
X_ISIR_CORR_STATUS_DATE => NULL ,
X_ISIR_STATUS => NULL ,
X_ISIR_STATUS_DATE => NULL ,
X_COA_CODE_F => NULL ,
X_COA_CODE_I => NULL ,
X_COA_F => NULL ,
X_COA_I => NULL ,
X_DISBURSEMENT_HOLD => NULL ,
X_FA_PROCESS_STATUS => NULL ,
X_NOTIFICATION_STATUS => NULL ,
X_NOTIFICATION_STATUS_DATE => NULL ,
X_PACKAGING_STATUS => NULL ,
X_PACKAGING_STATUS_DATE => NULL ,
X_TOTAL_PACKAGE_ACCEPTED => NULL ,
X_TOTAL_PACKAGE_OFFERED => NULL ,
X_ADMSTRUCT_ID => NULL ,
X_ADMSEGMENT_1 => NULL ,
X_ADMSEGMENT_2 => NULL ,
X_ADMSEGMENT_3 => NULL ,
X_ADMSEGMENT_4 => NULL ,
X_ADMSEGMENT_5 => NULL ,
X_ADMSEGMENT_6 => NULL ,
X_ADMSEGMENT_7 => NULL ,
X_ADMSEGMENT_8 => NULL ,
X_ADMSEGMENT_9 => NULL ,
X_ADMSEGMENT_10 => NULL ,
X_ADMSEGMENT_11 => NULL ,
X_ADMSEGMENT_12 => NULL ,
X_ADMSEGMENT_13 => NULL ,
X_ADMSEGMENT_14 => NULL ,
X_ADMSEGMENT_15 => NULL ,
X_ADMSEGMENT_16 => NULL ,
X_ADMSEGMENT_17 => NULL ,
X_ADMSEGMENT_18 => NULL ,
X_ADMSEGMENT_19 => NULL ,
X_ADMSEGMENT_20 => NULL ,
X_PACKSTRUCT_ID => NULL ,
X_PACKSEGMENT_1 => NULL ,
X_PACKSEGMENT_2 => NULL ,
X_PACKSEGMENT_3 => NULL ,
X_PACKSEGMENT_4 => NULL ,
X_PACKSEGMENT_5 => NULL ,
X_PACKSEGMENT_6 => NULL ,
X_PACKSEGMENT_7 => NULL ,
X_PACKSEGMENT_8 => NULL ,
X_PACKSEGMENT_9 => NULL ,
X_PACKSEGMENT_10 => NULL ,
X_PACKSEGMENT_11 => NULL ,
X_PACKSEGMENT_12 => NULL ,
X_PACKSEGMENT_13 => NULL ,
X_PACKSEGMENT_14 => NULL ,
X_PACKSEGMENT_15 => NULL ,
X_PACKSEGMENT_16 => NULL ,
X_PACKSEGMENT_17 => NULL ,
X_PACKSEGMENT_18 => NULL ,
X_PACKSEGMENT_19 => NULL ,
X_PACKSEGMENT_20 => NULL ,
X_MISCSTRUCT_ID => NULL ,
X_MISCSEGMENT_1 => NULL ,
X_MISCSEGMENT_2 => NULL ,
X_MISCSEGMENT_3 => NULL ,
X_MISCSEGMENT_4 => NULL ,
X_MISCSEGMENT_5 => NULL ,
X_MISCSEGMENT_6 => NULL ,
X_MISCSEGMENT_7 => NULL ,
X_MISCSEGMENT_8 => NULL ,
X_MISCSEGMENT_9 => NULL ,
X_MISCSEGMENT_10 => NULL ,
X_MISCSEGMENT_11 => NULL ,
X_MISCSEGMENT_12 => NULL ,
X_MISCSEGMENT_13 => NULL ,
X_MISCSEGMENT_14 => NULL ,
X_MISCSEGMENT_15 => NULL ,
X_MISCSEGMENT_16 => NULL ,
X_MISCSEGMENT_17 => NULL ,
X_MISCSEGMENT_18 => NULL ,
X_MISCSEGMENT_19 => NULL ,
X_MISCSEGMENT_20 => NULL ,
X_PROF_JUDGEMENT_FLG => NULL ,
X_NSLDS_DATA_OVERRIDE_FLG => NULL ,
X_TARGET_GROUP => NULL ,
X_COA_FIXED => NULL ,
X_COA_PELL => NULL ,
X_MODE => 'R' ,
X_PROFILE_STATUS => NULL ,
X_PROFILE_STATUS_DATE => NULL ,
X_PROFILE_FC => NULL ,
X_TOLERANCE_AMOUNT => NULL ,
x_manual_disb_hold => NULL ,
x_pell_alt_expense => NULL ,
x_assoc_org_num => NULL ,
x_award_fmly_contribution_type => '1',
x_isir_locked_by => NULL,
x_adnl_unsub_loan_elig_flag => 'N',
x_lock_awd_flag => 'N',
x_lock_coa_flag => 'N'
);