[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select card_id from ap_cards_all where card_id = p_card_id
for update of card_id;
delete from ap_card_emp_candidates where card_id = p_card_id;
'INSERT INTO ap_card_emp_candidates(card_id, employee_id, created_by, creation_date, last_updated_by, last_update_date, last_update_login)
SELECT card.card_id,
pap.person_id,
fnd_global.user_id,
trunc(sysdate),
fnd_global.user_id,
trunc(sysdate),
fnd_global.login_id
FROM PER_ALL_PEOPLE_F pap, FINANCIALS_SYSTEM_PARAMS_ALL fsp, PER_PERSON_TYPES ppt, AP_CARDS_ALL card
WHERE
card.CARD_ID = :cardId
AND card.ORG_ID = fsp.ORG_ID
AND TRUNC(sysdate) BETWEEN pap.effective_start_date AND pap.effective_end_date
AND pap.business_group_id = fsp.business_group_id
AND pap.business_group_id = ppt.business_group_id
AND UPPER(ppt.user_person_type) <> ''CONTACT''
AND pap.person_type_id = ppt.person_type_id'||l_where_clause
using p_card_id, l_full_name, p_national_id, p_employee_num;
CURSOR ccard IS SELECT full_name, first_name, middle_name, last_name, employee_number, national_identifier
FROM ap_card_details
WHERE card_id = p_card_id;