APPS.PAY_PAYMENT_TYPES_PKG dependencies on PAY_PAYMENT_TYPES_S

Line 46: SELECT Pay_Payment_Types_s.nextval

42: l_max_id pay_payment_types.payment_type_id%type;
43: BEGIN
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.

Line 60: SELECT Pay_Payment_Types_s.nextval

56: INTO l_max_id
57: FROM pay_payment_types;
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:

Line 616: SELECT pay_payment_types_s.nextval

612: --
613: -- exception
614: -- when NO_DATA_FOUND then
615: if (SQL%rowcount = 0) then
616: SELECT pay_payment_types_s.nextval
617: INTO X_PAYMENT_TYPE_ID
618: FROM dual;
619: INSERT INTO pay_payment_types(
620: PAYMENT_TYPE_ID,