APPS.PAY_PAYMENT_TYPES_PKG dependencies on DUAL

Line 48: FROM dual;

44: --
45: Is_Unique(X_Rowid,X_Payment_Type_Name,X_Territory_Code);
46: SELECT Pay_Payment_Types_s.nextval
47: INTO X_Payment_Type_Id
48: FROM dual;
49:
50: /* Defensive coding to prevent duplicate primary keys.
51: We've seen issues where the sequence on payment_type has been
52: reset and we end up selecting a sequence value which already

Line 62: FROM dual;

58:
59: WHILE X_Payment_Type_Id <= l_max_id LOOP
60: SELECT Pay_Payment_Types_s.nextval
61: INTO X_Payment_Type_Id
62: FROM dual;
63: END LOOP;
64:
65: INSERT INTO PAY_PAYMENT_TYPES(
66: payment_type_id,

Line 620: FROM dual;

616: -- when NO_DATA_FOUND then
617: if (SQL%rowcount = 0) then
618: SELECT pay_payment_types_s.nextval
619: INTO X_PAYMENT_TYPE_ID
620: FROM dual;
621: INSERT INTO pay_payment_types(
622: PAYMENT_TYPE_ID,
623: TERRITORY_CODE,
624: CURRENCY_CODE,