SELECT
    pgpl.paymentGroupID,
    pgpl.paymentGroupProductLinkID,
    pgpl.productID
INTO
    :paymentGroupID,
    :paymentGroupProductLinkID,
    :productID
FROM PaymentGroupProductLink pgpl, PaymentGroup
WHERE
      pgpl.paymentGroupID=PaymentGroup.paymentGroupID
  AND
      pgpl.productID=:productID
  AND
      PaymentGroup.recordStatus=:recordStatus