APPS.IBY_CREDITCARD_PKG dependencies on DUAL

Line 155: SELECT iby_creditcard_h_s.NEXTVAL INTO x_history_id FROM dual;

151: * If active_flag is not set for a particular credit card
152: * in IBY_CREDITCARD, default the value to 'Y', otherwise
153: * this method will throw a 'cannot insert NULL exception ..'
154: */
155: SELECT iby_creditcard_h_s.NEXTVAL INTO x_history_id FROM dual;
156: INSERT INTO iby_creditcard_h
157: (card_history_change_id, instrid, expirydate, expiry_sec_segment_id,
158: addressid,
159: description, chname, chname_sec_segment_id, finame, security_group_id,

Line 562: SELECT iby_instr_s.NEXTVAL INTO x_instr_id FROM DUAL;

558: l_masked_chname := p_holder_name;
559: END IF;
560: -- l_chname_length := NVL(LENGTH(p_holder_name), 0);
561:
562: SELECT iby_instr_s.NEXTVAL INTO x_instr_id FROM DUAL;
563:
564: INSERT INTO iby_creditcard
565: (instrid, ccnumber, masked_cc_number,
566: card_mask_setting, card_unmask_length, cc_number_hash1, cc_number_hash2,