APPS.IBY_CREDITCARD_PKG dependencies on DUAL

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

213: * If active_flag is not set for a particular credit card
214: * in IBY_CREDITCARD, default the value to 'Y', otherwise
215: * this method will throw a 'cannot insert NULL exception ..'
216: */
217: SELECT iby_creditcard_h_s.NEXTVAL INTO x_history_id FROM dual;
218: INSERT INTO iby_creditcard_h
219: (card_history_change_id, instrid, expirydate, expiry_sec_segment_id,
220: addressid,
221: description, chname, chname_sec_segment_id, finame, security_group_id,

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

678: l_masked_chname := p_holder_name;
679: END IF;
680: -- l_chname_length := NVL(LENGTH(p_holder_name), 0);
681:
682: SELECT iby_instr_s.NEXTVAL INTO x_instr_id FROM DUAL;
683:
684: INSERT INTO iby_creditcard
685: (instrid, ccnumber, masked_cc_number,
686: card_mask_setting, card_unmask_length, cc_number_hash1, cc_number_hash2,