[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ROWID, p.*
FROM igf_se_payment p
WHERE p.payroll_id = p_payroll_id
AND p.auth_id = p_auth_id
AND p.person_id = p_person_id;
SELECT se.fund_id
FROM igf_se_auth se
WHERE se.flag = 'A'
AND se.person_id = p_person_id
AND se.auth_id = p_auth_id;
SELECT party_number
FROM hz_parties
WHERE party_id = cp_person_id;
igf_se_payment_pkg.update_row(
x_rowid => c_check_payroll_rec.rowid,
x_transaction_id => c_check_payroll_rec.transaction_id,
x_payroll_id => c_check_payroll_rec.payroll_id,
x_payroll_date => p_payment_record.payroll_date,
x_auth_id => c_check_payroll_rec.auth_id,
x_person_id => c_check_payroll_rec.person_id,
x_fund_id => c_check_payroll_rec.fund_id,
x_paid_amount => p_payment_record.paid_amount,
x_org_unit_cd => p_payment_record.organization_unit_name,
x_source => p_payment_record.source,
x_mode => 'R'
);
igf_se_payment_pkg.insert_row(
x_rowid => l_rowid,
x_transaction_id => l_transaction_id,
x_payroll_id => p_payment_record.payroll_id,
x_payroll_date => p_payment_record.payroll_date,
x_auth_id => p_payment_record.authorization_id,
x_person_id => p_payment_record.person_id,
x_fund_id => l_fund_id,
x_paid_amount => p_payment_record.paid_amount,
x_org_unit_cd => p_payment_record.organization_unit_name,
x_source => p_payment_record.source,
x_mode => 'R'
);